Forum Discussion

SarikaB's avatar
SarikaB
Regular Visitor
5 years ago

Cummulative Sum Based on Same Rank Issues

Hello Team, 

 

I am trying to do a Cummulative Sales based on Rank

 

Here, is my 

Rank Measure=

mRank = RANKX(ALL(PostedSalesInvoiceLines[No],PostedSalesInvoiceLines[CustName]),[mTotalSales],,DESC,Dense)
Cummulative Sales Measure:
mCumSsales = CALCULATE ([mTotalSales],TOPN([mRank],ALL ( 'PostedSalesInvoiceLines' ),[mTotalSales]))

 

Cummulative sum is not happening during same ranks.

 

Kindly let me know how to resolve.

 

Regards,

Sarika

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    5 years ago

    mCumSsales = VAR _rx=[mRank] RETURN CALCULATE ([mTotalSales],FILTER(ALL(PostedSalesInvoiceLines[No],PostedSalesInvoiceLines[CustName]),[mRank]<=_rx))