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...
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 - ?