Value calculation, measure

[topazz11]

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.

eventually i will just need one final value, 2.6

Desired output: I'd like to use the value on the card visual

Thanks!

[Greg_Deckler · Accepted solution]

@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.