Forum Discussion

DiePic's avatar
DiePic
Icon for Resolver II rankResolver 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[TktTempoAccettazione]))
  //
    VAR Filtra =
    IF(ReplyTime < 61
      , 0
      ,IF([Tempo_Risposta_Concordato] = 0
        ,0
        ,IF(([Tempo_Risposta_Concordato] - ReplyTime) >= 0
          ,0
          ,1
        )
      )
    )  
VAR Result = VALUE(Filtra)
RETURN Result

as highlighted in red, I have not found a formula to sum my measure .... I tried all the ways shown in the figure below

If somebody can give me help or give some idea ... it will be appreciated

 



Need Help
  • DiePic's avatar
    DiePic
    2 years ago

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

    SUMX( VALUES('table'[id]) ,[MyMeasure])

4 Replies

  • DiePic's avatar
    DiePic
    Icon for Resolver II rankResolver II
    2 years ago

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

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

      DiePic Yep, you got it, would be the equivalent of this using a more generalized method (below). Also, you might consider using DISTINCT instead of VALUES. VALUES has a nasty habit of returning a blank row when you have unmatched keys in a relationship.

      SUMX( SUMMARIZE('table', [id], "__MyMeasure", [MyMeasure]), [MyMeasure] )

      The advantage of this generalized approach is that one, SUMMARIZE tends to be crazy fast. Two, if you need to "group" by more than one thing, SUMMARIZE can do this while just using DISTINCT or VALUES cannot.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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
      Icon for Resolver II rankResolver 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