Forum Discussion
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],,...
mCumSsales = VAR _rx=[mRank] RETURN CALCULATE ([mTotalSales],FILTER(ALL(PostedSalesInvoiceLines[No],PostedSalesInvoiceLines[CustName]),[mRank]<=_rx))