Forum Discussion

Lidou_Cand's avatar
Lidou_Cand
Helper III
5 years ago

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?

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Lidou_Cand , Numeric columns are summable, You can create a measure.

    Both should work. Set default summarization /aggregation in column tool

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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.