Select Max value from slicer even with blank values

[technicneo]

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 value can be blank.
However, I need this value (even if it's blank) in order to continue with another calculation.

Is this even possible to compute?

[AntonioHR_]

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]

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.