Forum Discussion
IF statement in Measure, need help
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!
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,
2 Replies
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,
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 0will really appreciate your assistance
