Wrong Sum of Total of a measure that evaluate to 1 or 0 with IF sentence?

[Bokazoit]

I have this measure:

ColdSpotClm = IF(SUM(Test[Udbudte]) > 18 && [Belægningsprocent]<0,6;1;IF(SUM(Test[Udbudte]) >= 6 && SUM(Test[Udbudte])<=18 && [Belægningsprocent]<0,5;1;IF(SUM(Test[Udbudte]) >= 3 && SUM(Test[Udbudte])<= 5 && [Belægningsprocent]<0,4;1;0)))

Evaluates to 1 or 0 depending on the above condition. But the total is also evaluated were I would expect a sum of all the 1's. In the picture below measure is in the last column and evaluates each row correctly, but the sum is evaluated but I would expect it to show the sum 12. How to do that?

[v-yuezhe-msft]

@Bokazoit,

Please create another measure in your table using DAX below and drag it to the table visual.

NewMeasure = IF(COUNTROWS(VALUES(Test[healthcentername]))=1, [ColdSpotClm],SUMX(VALUES(Test[healthcentername]),[ColdSpotClm]))

If the above measure doesn't return correct result, please share sample data of your table here.

Regards,
Lydia

[Stachu]

I would rewrite the measure as a calculated column, and apply it there

of if it has to be a measure then use SUMX to get the total result of column added via ADDCOLUMN

[Bokazoit]

How to rewrite to use the SUMX ? I tried and I can not use calculated column since I need to calcualted based on period interval

[Stachu]

can you share sample anonymised data, as well as syntax from the used measures? without it I can just give general advice as I did in the previous post