Pareto 80/20 Count amount

[Marc_TrueLime]

Hi guys,

I'm trying to count the amount of records (accounts) based on the value in a specific column ('8020_groepering'). It's in regards to a Pareto (80/20)-analysis for which I found a great deal of  other topics on this forum which really helped me, but I'm stuck on this final issue.

First column is the order of accounts based on sales in the selected period, but the final step is 'simply' counting the amount of accounts which are responsible for 80% of turnover (should be 25, as indicated in the screenshot). Could somebody give me a hint on how to proceed. 

FYI, all mentioned columns are measures, which are all in the same table as all actual sales-data (I'm not sure if that makes any difference).

[v-eachen-msft · Accepted solution]

Hi @Marc_TrueLime ,

You can use this measure to get your result.

8020_Accounts80 =
CALCULATE (
    COUNTROWS ( DISTINCT ( 'Table'[Name] ) ),
    FILTER ( ALL ( 'Table' ), [Measure] = 80 )
)

Here is my test result.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.