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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I need to calculate cumulative sum of Pictures per site
Picture per site is a measure which is straight count of index column.
Site Score is also a measure.
I need a new measure which should calculate the cumulative sum of Pictures per site for site score in descending order.
Thank you
CumSum=SUMX(WINDOW(0,ABS,0,REL,ADDCOLUMN(ALLSELECTED(Table[Site/Link]),"@SiteScore",[Site Score]),,ORDERBY([@SiteScore],DESC,Table[Site/Link],ASC)),[Pictures per Site])