Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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 0
will really appreciate your assistance
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,
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |