SUM a measure

[DiePic]

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

[DiePic · Accepted solution]

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

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

[Greg_Deckler]

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

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

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