Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |