Interaction between RANKX and TOPN for ABC ( Paretto ) Analysis

Hi Leandro_Filho ,

Rankx function, it ‘Returns the rank of an expression in the current context in the list of values for the expression evaluated for each row in the specified table’. 

Please try changing ALLSELECTED to ALL in the measure.

If you want to sort the cumulative volume, then use the sumx function.

I recommend that you refer to the following links to learn how to use the RANKX function in the TOPN function:

Power BI Pro Tip: Pareto analysis with DAX / Power Pivot · Dutch Data Dude

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Best Regards,

Neeko Tang

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