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

     

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.