Forum Discussion

topazz11's avatar
topazz11
Helper III
3 years ago
Solved

Value calculation, measure

I'd like to get the calculated value so I can use it on the card. -data is pretty simple. total count is 10 but i am having trouble to get % count of total and expected value by category. ev...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    topazz11 Assuming that your Expected Value is a measure, you can use measure aggregation. 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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

topazz11 Assuming that your Expected Value is a measure, you can use measure aggregation. 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.