Need to add two measures based on a condition

[ashrat001]

Hi All,

I need your input as, I want to add two measures based on a simple condition.

Addition =IF(Measure1 >= -1* (Measure2) ,(Measure1 + Measure2),0)

Secondly, should I use measures with Query Name or simple measures names in the formula. Thanks!

Tariq Ashraf

[Anonymous]

Show the definitions of the measures. Most likely, the measures are written very inefficiently and require a lot of memony because of materialization.

[Anonymous]

Your measure is really [Addition] = max( [Measure1] + [Measure2], 0 ). Measures should never be preceded by the name of the table they reside in. Columns should always be preceded by their host tables' names. This is the rule in DAX.

[amitchandak]

@ashrat001 , what is the problem you are facing

Addition =IF([Measure1] >= -1* ([Measure2]) ,([Measure1] +[ Measure2]),0)

or

sumx(values(Table[Some ID]),IF([Measure1] >= -1* ([Measure2]) ,([Measure1] +[ Measure2]),0))

[ashrat001]

Hi Amit,

This formula is not working.

Balance = If([Meaure1] >= [Measure2], [Measure1] + [Measure2],0)

I'm getting following error:

Couldn't load the data for this visual. There's not enough memory to complete this operation. Thanks!

Tariq