Cumulative Sum - What am I missing?

Hi,

Try these measures

Rank = if([Disti Net Sales] = BLANK(),BLANK(),RANKX(ALL('Sales data'[City]),[Disti Net Sales]))

Cumulative Disti Net sales = SUMX(TOPN([Rank],CALCULATETABLE(VALUES('Sales data'[City]),ALL('Sales data'[City])),[Disti Net Sales]),[Disti Net Sales])

Cumulative Disti Net sales (%) = [Cumulative Disti Net sales]/CALCULATE([Cumulative Disti Net sales],all('Sales data'[City]))

Hope this helps.

Hi Ashish_Mathur ,

Thank you for the measures. The cumulative % measure was not working, but I edited it to :-

Cumulative Disti Net Sales % = 
DIVIDE( [Cumulative Disti Net Sales] ,
    CALCULATE(SUM('Sales Data'[Invoice-Doc]), ALL('Sales Data'[City])) , 
    BLANK()
)

And it's showing the cumulative percentages now.