Forum Discussion

AndreaSo's avatar
AndreaSo
Frequent Visitor
3 years ago
Solved

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 cat...
Need Help
Show and Tell
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

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's avatar
AndreaSo
Frequent Visitor
3 years ago
You are correct, the value 5 does not need to be shown explicitly, it just need to be the total of the whole circle.