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

Need Help

2 Replies

  • 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.