Forum Discussion
Column or measure ?
Hello All, I have a question about measures. In my current job, I have a numeric column which is not summable. Can I turn it into a measure? Is there a measure that we cannot aggregate?
Lidou_Cand - Not sure what you mean by a numeric column that is not summable. Can you explain that?
You can aggregate measures. 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.