IF statement in Measure, need help

[karimkz]

Hi,

I want my Measure to change value, based on a selected Unit.

Just like that: 

So how do I write something like: 

          IF (car_id=0109) then Measure=22  (doesn't work this way) 

Or: 

          IF (selected(0109) then Measure=22; 

 In DAX actually. Thanks for help, I appreciate!

[Anonymous]

Hi Team

i need some assistance with converting this to a measure

if[AffiliateOwnerID]=3 and [ActivityTypeID]=1 or[ActivityTypeID]=2 then 2
else if [AffiliateOwnerID]=3 and [ActivityTypeID]=41 then 10
else if [AffiliateOwnerID]=3 and [ActivityTypeID]=6 or [ActivityTypeID]=42 then 5
else if [AffiliateOwnerID]=3 and [ActivityTypeID]=43 then 12
else 0

will really appreciate your assistance

[v-sihou-msft · Accepted solution]

@karimkz

In DAX, Measure is always sliced by current row context, it's not possible to use the current slicing row as condition in Measure. In your scenario, you can create a dummy measure for this conditon. Just create a measure like:

Dummy = SUM(Table[car_id])

Then you can create a calculated measure like:

Measure =IF([Dummy]=112,22,[Measure_Gauge])

Regards,