topic Re: Help with DAX in DAX Commands and Tips

Help with DAX

Anonymous — Tue, 29 Sep 2020 10:06:25 GMT

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

Re: Help with DAX

amitchandak — Tue, 29 Sep 2020 10:50:23 GMT

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

Re: Help with DAX

Anonymous — Tue, 29 Sep 2020 11:03:19 GMT

Thank you for the quick reply!

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