pie chart and distinct count

[AndreaSo]

Hi, I went through several similar solutions but I still did not get to understand how to solve the problem.

From data below, I have 5 different products (a1,a2,a3,a4,a5) and some of them are categorised with 8D 8115, this represents that the product has a fault. 

I would like to show on a pie grapth how many products we have in total (in this case 5), how many products have defect (in this case a1,a3 and a2) and not affected 2 (a4, a5).

This is the data example:

I tried to use distinct coult of Serial number and add Category into the legend, but this is the result.

Thank you in advance for help. 

[DOLEARY85 · Accepted solution]

Hi,

could you create 2 measures to calculate to totals e.g:

Issue = VAR __Table = ADDCOLUMNS('Table',"Categort",[Category])

RETURN

  COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,NOT([Category]="")),"Serial number",[Serial number])))

No Issue = CALCULATE(DISTINCTCOUNT('Table'[Serial number]))-[Issue]

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[AndreaSo]

You helped me! It works, thank you a lot. 🙂 

[PhilipTreacy]

Hi @AndreaSo 

So you want to show the values 5, 3 and 2?  Why the need to show the total also, why not just add 3 + 2?  maybe I  misunderstand?

Phil

[AndreaSo]

You are correct, the value 5 does not need to be shown explicitly, it just need to be the total of the whole circle.