Help with DAX - Counting outcome of a measure

[Anonymous]

I'm trying to create a measure which counts whether a customer contributed to the top 80% of the revenue. 

At the moment I have the following data: 

rank  |  debtor   |    Revenue    |     Revenue cumulative   |  % of total revenue   |   < 80%

1         a                       350                        350                           54%                              1

2         b                       300                        650                           100%                            0

Total                            650             

Less then 80% is a measure created by using the switch function

< 80% = CALCULATE(SWITCH(TRUE(),

[% of total revenue] <=0.8 && [% of total revenue]>0, 1,BLANK()))

In a card i would like to show the total of customers contributed to 80% of the revenue (so how many times the outcome of the switch function is equal to 1).

Thanks in advance for your help! 

[Anonymous]

Hi @Anonymous 

just add a card with the Measure "< 80%".

Or understand you wrong?!

BR
Timo

Edit: You are able to select the SUM for the Measure "<80%"

[Anonymous]

Hi @Anonymous , 

Unfortenately thats not working. A card will show me the value 1, as it will ignore all the different debors and shows me the sum of all the revenues divided by the cumulative revenue. The outcome will be 100%, so the card will show me the value 1. 

[Anonymous]

Hi @Anonymous ,

I try to reproduce your report/data. Are "Revenue cumulative" and  "% of total revenue" custom columns or custom measures or are they part of the import?

Do you import a file or is it a direct query?

BR
Timo  

[Anonymous]

Hi @Anonymous , 

these are all custom measures. I don't use import, i'm working with Direct Query!

Kind Regards,

Annabel 

[Anonymous · Accepted solution]

Hi @Anonymous ,

please try this:

Amount = SUMX ( VALUES ( 'TableName'[debtor]), [< 80%])

BR
Timo

[Anonymous]

@Anonymous Works perfect!!! Thanks!! 🙂