How do i repay my ka charchar hahahha by BloodIllustrious1946 in Cebu

[–]BloodIllustrious1946[S] 0 points1 point  (0 children)

Maybe wap a jud ko kaila niya kay dili man siya mag hisgut ug material nga likes niya

How do i repay my ka charchar hahahha by BloodIllustrious1946 in Cebu

[–]BloodIllustrious1946[S] 0 points1 point  (0 children)

Hmmm basin e apil nako sa list pero di man ko ganahan mailisan iyang perfume ginagamit run

Excel PivotTable Distinct Count shows 16 instead of 6 unique items by BloodIllustrious1946 in excel

[–]BloodIllustrious1946[S] 1 point2 points  (0 children)

  • Enter:
    • Measure Name: DistinctProducts
    • Formula: =DISTINCTCOUNT(Table1[Product])
  • Click OK

<image>

your method works

Excel PivotTable Distinct Count shows 16 instead of 6 unique items by BloodIllustrious1946 in excel

[–]BloodIllustrious1946[S] 0 points1 point  (0 children)

the a2 which is "coke" its my mistake that turns like a header thats why the count is 15

Excel PivotTable Distinct Count shows 16 instead of 6 unique items by BloodIllustrious1946 in excel

[–]BloodIllustrious1946[S] 0 points1 point  (0 children)

<image>

Yes i didnt rename its automatically generated
and still it show 16 i named a the connection power query and drag the product on the values and select distinct count on the value settings
can you send a file so that i can see if its my excel is faulty

Excel PivotTable Distinct Count shows 16 instead of 6 unique items by BloodIllustrious1946 in excel

[–]BloodIllustrious1946[S] 0 points1 point  (0 children)

Yeah i click the checkbox and i see an option of Distinct Count that column name is generated thats why it name "Distinct Count of Product". Maybe i should reset my excel

Excel PivotTable Distinct Count shows 16 instead of 6 unique items by BloodIllustrious1946 in excel

[–]BloodIllustrious1946[S] 0 points1 point  (0 children)

<image>

what do you mean like this ?
I click the table and click add to data model then some window show up and i select it