Forum Discussion

Marc_TrueLime's avatar
Marc_TrueLime
Frequent Visitor
7 years ago
Solved

Pareto 80/20 Count amount

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





 

 

 

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    7 years ago

    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.

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.