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 way) 

Or: 

          IF (selected(0109) then Measure=22; 

 

 In DAX actually. Thanks for help, I appreciate!

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,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    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