Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Percentages 100% Help!

Hi there! I need to do a percentage calculation of two different measures, but I need one to be filtered and one to be ALL. Below are my measures:   SalesCount= DISTINCTCOUNT(Sales[Purchase...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    I have found a solution!

    1)     SalesCount= DISTINCTCOUNT(Sales[PurchaseID])

     

    2)     GradesOut= CALCULATE(DISTINCTCOUNT(Sales[PurchaseID]),FILTER(Purchases,Purchases[GradeDiff]>0))

     

    3)     AllSales = CALCULATE([SalesCount],ALL(Sales))

     

    4)     %Of Sales = DIVIDE([GradesOut],[AllSales],0)

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I get the following error message:

The syntax for ')' is incorrect. (DAX(distinctcount(all(sales[PurchaseID]))))).

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have found a solution!

1)     SalesCount= DISTINCTCOUNT(Sales[PurchaseID])

 

2)     GradesOut= CALCULATE(DISTINCTCOUNT(Sales[PurchaseID]),FILTER(Purchases,Purchases[GradeDiff]>0))

 

3)     AllSales = CALCULATE([SalesCount],ALL(Sales))

 

4)     %Of Sales = DIVIDE([GradesOut],[AllSales],0)