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 👍

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
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 👍

  • AndreaSo's avatar
    AndreaSo
    Frequent Visitor
    3 years ago

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