topic Re: Select Max value from slicer even with blank values in DAX Commands and Tips

Select Max value from slicer even with blank values

technicneo — Tue, 11 Jun 2024 09:03:18 GMT

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?

Re: Select Max value from slicer even with blank values

AntonioHR_ — Tue, 11 Jun 2024 10:26:57 GMT

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

Re: Select Max value from slicer even with blank values

technicneo — Tue, 11 Jun 2024 11:02:43 GMT

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.