Cumulative SUM by RANK of volume

[riccardoprade93]

Hi guys,

I am have been stucked for few days on this, which I thought to be very easy.

As you can see in the screenshot, I have some Products (DFU) and their relatived KGs of volume sold, then I ranked them by top volume and down. 

Rank measure: 

Rank = RANKX(ALLSELECTED('Current Cns'[DFU]),CALCULATE(([Quantity KG])),,DESC,Dense)

Now I would like to have another measure that calculate the cumulative sales, the intention is to create the ABC by total volume.

I have tried so many combos, none of them works... I think the problem is mostly related to the fact that this is a dynamic measure, remember that the rank is a measure as well. Any suggestion? Thanks.

 Thanks a lot, Riccardo

[Padycosmos]

Could you please show the measure [Quantity KG]?

Otherwise the formula seems to be correct

[riccardoprade93]

Quantity KG = CALCULATE(SUM('Current Cns'[QUANTITY]))

[Padycosmos]

The formula is correct. I have no clue as to why the formula is not working, the only reason could be unrelated to the formula

[riccardoprade93]

I think is working, just is not able to load this much data.

[Padycosmos]

You may try creating a calculated column for rank instead of a measure and use the measure for Cumulative Quantity

[riccardoprade93]

I will try, thanks for the suggestion.

[Padycosmos]

Hope this helps:

[riccardoprade93]

 it seems the formula does not have issue, but it is not able to run it. The left charging circle  keep going on without finalzing... any idea on why?

[amitchandak]

@riccardoprade93 , Check

Power BI Window: Pareto Analysis Again, 80% of sales, ABC Analysis , Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

[riccardoprade93]

Hi, thanks a lot, it seems working for you. Do you know why in mine does not?

it looks like is not able to run it, any idea?