Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello Team,
I am trying to do a Cummulative Sales based on Rank
Here, is my
Rank Measure=
Cummulative sum is not happening during same ranks.
Kindly let me know how to resolve.
Regards,
Sarika
mCumSsales = VAR _rx=[mRank] RETURN CALCULATE ([mTotalSales],FILTER(ALL(PostedSalesInvoiceLines[No],PostedSalesInvoiceLines[CustName]),[mRank]<=_rx))
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |