Forum Discussion

Sbezkoro's avatar
Sbezkoro
Regular Visitor
4 years ago
Solved

Why my measure remove external date filter?

I wish to calculate free capacity which is math difference between 100% and Loading, %. [Loading, %] - is a measure which calculated from inputs file as: Loading, % =     CALCULATE( SUM(InputFile...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Does this work better?

    Free Capacity, % =
VAR Loading = [Loading, %]
RETURN
    IF (
        ISBLANK ( Loading ),
        BLANK (),
        MAX ( 1 - Loading, 0 )
    )

     

Sbezkoro's avatar
Sbezkoro
Regular Visitor
4 years ago

In order to make it work I replaced all nulls with "0" in query (inputs file). It, unfortunatelly increased my dataset, but at least I have now only zeros (no empty) and it works fine.

Thanks!