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[PurchaseID]) -----To get the total number of sales

GradesOut= CALCULATE(DISTINCTCOUNT(Sales[PurchaseID]),FILTER(Purchases,Purchases[GradeDiff]>0)) --- to get all sales graded >0

Now I need to work out the percentage of GradesOut / SalesCount.......... but so that the SalesCount stays the same even after I have used a visualisation filter on the GradesOut.

 

I have used %GradesOut=DIVIDE([GradesOut],[SalesCount]))


This gives me the correct percentage, until I begin to filter. Then it changes my percentages to 100% and my number of SalesCount to equal the number of GradesOut.

 

If someone could help I would be eternally greatful! 

 

Please see below.

 

 




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)

     

     

3 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    7 years ago

    What does making SalesCount = distinctcount(all(sales[PurchaseID])) do?

    • 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)