Forum Discussion

DiePic's avatar
DiePic
Resolver II
2 years ago
Solved

SUM a measure

Hi all, I've this measure (last column)    and this is the code of the measure: Tempo_Risposta_Concordato_Count = //   VAR ReplyTime = VALUE(SELECTEDVALUE(Ticket_Data[TktTempoAccettaz...
Need Help
  • DiePic's avatar
    DiePic
    2 years ago

    If can be useful for someone, this is my solution:

    SUMX( VALUES('table'[id]) ,[MyMeasure])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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

  • DiePic's avatar
    DiePic
    Resolver II
    2 years ago

    Hi Greg_Deckler thank you for your suggestion.
    This is really over my knowledge ... can you help me more please?
    I try:

    MAXX(SUMMARIZE ( Ticket_Data, Ticket_Data[TktTempoAccettazione] , "Measure",[Tempo_Risposta_Concordato_Count] ), [Measure])
    but its not working