Forum Discussion

technicneo's avatar
technicneo
Frequent Visitor
2 years ago

Select Max value from slicer even with blank values

Hi there, following problem: I have to create a dax formula, that retrieves me the max value when using a slicer. The tricky part is, that when certain filters are applied to the data, the max val...
Need Help
AntonioHR_'s avatar
AntonioHR_
Frequent Visitor
2 years ago

Hi,

 

I'm guessing you need it as a 0 to continue with the next measure? If not you could change the 0 for any value you want to use when is blank.

Measure= IF(ISBLANK(MAX(value)) = TRUE;  0 ; MAX(value))

  • technicneo's avatar
    technicneo
    Frequent Visitor
    2 years ago

    Hi AntonioHR_,

    sadly it's a bit more complicated.

    The return value should be the variable sliced value (however it does not contain any values), so I'm assuming, that an IF Statement isn't the propper operator in this case.