Forum Discussion

karimkz's avatar
karimkz
Advocate I
9 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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