sum of measure

[Dunner2020]

Hi there,

I have a measure which looks like below:

Normalised 30 Mins Values = IF([Raw value 24 hrs ] > 5.69 && [Raw value 30 Mins ] > 5.69/48,5.69/48,[Raw value 30 Mins])

Now I want to create another measure that sums up the values created by the above-mentioned measure. I tired sum function but it did not work. Could anyone help me please?

[Greg_Deckler]

@Dunner2020 - 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.

[amitchandak]

@Dunner2020 , Try a measure like

sumx(Table ,IF([Raw value 24 hrs ] > 5.69 && [Raw value 30 Mins ] > 5.69/48,5.69/48,[Raw value 30 Mins]))

[Anonymous · Accepted solution]

HI @Dunner2020 

try 

SUMX(table,[Normalised 30 Mins Values])

OR

SUMX('Table',IF([Raw value 24 hrs ] > 5.69 && [Raw value 30 Mins ] > 5.69/48,5.69/48,[Raw value 30 Mins]))