Pareto analysis

Question

Hello people, I need help! I want to do an 80/20 analysis I made the table below with the following DAX:

Inventory value = sum(Inventory[Inventory ($)])

Rank =RANKX( ALL(Register[Code]), [Inventory value],, DESC )

Inventory value Acc =CALCULATE([Inventory value], TOPN([Rank], ALL(Register[Code]), [Inventory value], DESC))

However, when I put an attribute of the product code, the classification (rank) is lost and distorts my analysis, as follows:

How do I make an analysis correct applying attributes into the product code (ex.: types, family and others)?

Thanks in advanced

vanessafvg · Answer

what are you expecting to see in your results?  can you please provide an example

william_moreno · Answer

Hello, thanks for your reply!

I expected the ranking to remain the same, it means that the highest value keeps number 1 and not have repeated numbers.

If you notice it ranks by the type of product, but the type is just an attribute.

I would wish that the return it was like the table below:

vanessafvg · Answer

try this
&nbsp;
Rank =CALCULATE (RANKX ( ALLSELECTED ( Register[Code] ), CALCULATE ( [Inventory value] ) ),ALLEXCEPT ( Register, Register[Code] ))

Forum Discussion