Pie/Donut Chart - Percentage of Total with Distinct Count

[lmlearning]

Hello,

I am fairly new to Power BI and have tried searching through this forum for help on my question to no avail. I am trying to build a pie/donut chart with distinct count but found that the visual will use a grand total of the distinct count from each category instead of the distinct count of the whole (like it does in the table). Is there a specific meausre I need to use to force it to to give me the percentage of total like it does in the table? Dummy data and screenshots below.

Expectation:

• Distinct Count of ID for Type (e.g. how many unique IDs bought the type of product) and the percentage of total of distinct count (i.e. 7 different people bought the 4 products listed).
• Percentage of total on the pie chart to reflect the % in the table on the upper right of the screenshot (total = 7).

Result:

• Percentage of total on the pie chart shows % of the grand total of each category (total = 10), which double counts certain IDs.

I've tried doing distinct count 3 different ways and still gives me the same result:

• Right-click in values in the visual for distinct count
• Measure = DISTINCTCOUNT ('TEST-Table'[ID] )
• Measure = CALCULATE ( DISTINCTCOUNT ('TEST-Table'[ID]) , ALL ('TEST-Table') )

ID	Date	Type
AA	1/1/2021	Desk
AA	1/1/2020	Desk
AA	12/20/2020	Desk
AA	12/20/2021	Desk
BB	1/1/2021	Desk
BB	1/1/2020	Desk
BB	12/20/2020	Desk
BB	12/20/2021	Desk
CC	6/8/2020	Chair
CC	12/20/2020	Chair
DD	12/20/2021	Chair
EE	1/1/2021	Chair
EE	1/1/2020	Chair
EE	1/1/2021	Chair
EE	1/1/2020	Mat
EE	12/20/2020	Mat
EE	12/20/2021	Mat
EE	6/8/2020	Phone
EE	12/20/2020	Chair
FF	1/1/2021	Mat
FF	1/1/2020	Mat
GG	12/20/2020	Mat
GG	12/20/2021	Phone
GG	1/1/2021	Phone

Thank you in advance for your help!!

[lmlearning]

Hi Syk,

Thank you for the explanation! It brings to light some context I was missing with thinking about counts.

With that in mind, let's say I do want to intentionally count number of unique IDs to come to a total of 7 in the pie chart so I can arrive at the percentage shown outside of the parentheses in the screenshot below, is there a way to do so? (Sorry if this is a dumb question.)

To get the intended pecentages, I used this:

Measure =

VAR DistCountID = DISTINCTCOUNT('TEST-Table'[ID])

VAR TotalID = CALCULATE(DISTINCTCOUNT('TEST-Table'[ID]), ALL('TEST-Table'))

RETURN

DIVIDE(DistCountID, TotalID)

But even if I turn off the percentage of total label in the pie chart visual, when I hover over the slices, it would still give me percentage of total in parentheses.

Thank you again!

[Syk]

You can turn off tooltips!

[lmlearning]

I feel silly not having known that! Thank you so much for your time!!

[Syk]

I believe its doing what you want. The reason you are getting 10 is because you have a certain ID purchasing more than 1 type of item (ID EE buys chair, mat, and phone)

Also, your distinct count column is totaling incorrectly. They should both say 10 in each table.

[Syk]

I should mention, the reason your total is wrong is because the total is counting the number of distinct IDs with no regard to what they bought (so 7 total people).. The rest of the column counts each ID specific to what type of item was bought (EE is 1 person counted in the total but you could find them in 3 of those rows). I hope this makes sense!