Forum Discussion
pie chart and distinct count
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.
Hi,
could you create 2 measures to calculate to totals e.g:
Issue = VAR __Table = ADDCOLUMNS('Table',"Categort",[Category])RETURNCOUNTROWS(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 👍
4 Replies
Hi,
could you create 2 measures to calculate to totals e.g:
Issue = VAR __Table = ADDCOLUMNS('Table',"Categort",[Category])RETURNCOUNTROWS(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 👍
You helped me! It works, thank you a lot. 🙂
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
- You are correct, the value 5 does not need to be shown explicitly, it just need to be the total of the whole circle.
