Forum Discussion
Helper ICumulative of a measure based on Ranking
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.
Hi PerAsperaAdAstr ,
Please refer to my .pix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Greg_Deckler
Community Champion
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. - amitchandak
Super User
PerAsperaAdAstr , in the quick measure there is an option for running total. Try to use that
v-lionel-msftCommunity Support
Hi PerAsperaAdAstr ,
Please refer to my .pix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
