Cumulative of a measure based on Ranking

[PerAsperaAdAstr]

I have tried to research this online but couldn't find anything suitable and I've tried different methods.

I've created 2 measures: (1) rank in column 3 (2) percentage of total

How do I create a measure for the cumulative sum of the percentages?

As always, any help is much appreciated.

[v-lionel-msft · Accepted solution]

Hi @PerAsperaAdAstr ,

Please refer to my .pix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PerAsperaAdAstr , in the quick measure there is an option for running total. Try to use that

[Greg_Deckler]

@PerAsperaAdAstr This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.