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],,...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

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