DAX Help

[Anonymous]

Hello!

If either vehicle_id or Date is filtered my visuals should show a calculation of max-min but if neither of them are filtered it should show BLANK. With this code i'm getting an error "Too many arguments were passed to the ISFILTERED function".

VAR minimi = MIN(YhdistettyTaulu[fuelconsumption_value])

VAR maksimi = MAX(YhdistettyTaulu[fuelconsumption_value])

return

IF(ISFILTERED('YhdistettyTaulu'[vehicle_id]) || (ISFILTERED(('YhdistettyTaulu'[Date]) ; maksimi - minimi ; BLANK())))

[Fowmy · Accepted solution]

@Anonymous 

Can you try this version?

VAR minimi = MIN(YhdistettyTaulu[fuelconsumption_value])
VAR maksimi = MAX(YhdistettyTaulu[fuelconsumption_value])
return
IF(
    ISFILTERED('YhdistettyTaulu'[vehicle_id]) || ISFILTERED('YhdistettyTaulu'[Date]);
    maksimi - minimi ; 
    BLANK()
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Thank you for your help!