Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help with DAX

Hello!

 

I'm trying to make a measure that shows values in my visualization only if a vehicle ID or a Date is selected from a filter. So far my measure only returns a value after substracting MIN from MAX.
 
Measure = CALCULATE (IF(ISFILTERED(YhdistettyTaulu[vehicle_id] = 
(A DAX syntax that i started but don't know how to finish)

VAR minimi = MIN(YhdistettyTaulu[fuelconsumption_value])
VAR maksimi = MAX(YhdistettyTaulu[fuelconsumption_value])
RETURN maksimi - minimi
 
 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try like

     

    Measure =
    VAR minimi = MIN(YhdistettyTaulu[fuelconsumption_value])
    VAR maksimi = MAX(YhdistettyTaulu[fuelconsumption_value])
    return
    IF(ISFILTERED(YhdistettyTaulu[vehicle_id] ) , maksimi - minimi , blank())

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you for the quick reply!

       

      It does work but what if instead of blank i want the visual to showcase only - ?