topic Re: Need to add two measures based on a condition in DAX Commands and Tips

Need to add two measures based on a condition

ashrat001 — Wed, 04 Nov 2020 12:12:30 GMT

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

Re: Need to add two measures based on a condition

amitchandak — Wed, 04 Nov 2020 13:13:05 GMT

ashrat001 , what is the problem you are facing

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

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

Re: Need to add two measures based on a condition

Anonymous — Wed, 04 Nov 2020 14:06:17 GMT

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.

Re: Need to add two measures based on a condition

ashrat001 — Thu, 05 Nov 2020 06:42:52 GMT

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

Re: Need to add two measures based on a condition

Anonymous — Thu, 05 Nov 2020 08:31:50 GMT

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