Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply

Cumulative SUM by RANK of volume

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

 

riccardoprade93_0-1677582005602.png

 

10 REPLIES 10
Padycosmos
Solution Sage
Solution Sage

Could you please show the measure [Quantity KG]?

Otherwise the formula seems to be correct

Quantity KG = CALCULATE(SUM('Current Cns'[QUANTITY]))
 
riccardoprade93_0-1677668632655.png

 

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

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

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

I will try, thanks for the suggestion.

Padycosmos
Solution Sage
Solution Sage

Hope this helps:

Padycosmos_0-1677666737646.png

 

riccardoprade93_1-1677667545629.png

 

 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
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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?

riccardoprade93_0-1677660789582.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.