Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

HELP WITH A MEASURE

Good afternoon everyone, I need help with a measure: I have the following measures:

Total Rooms

Total Rooms SPLY,

I need a logical function that tells me: if Total Rooms SPLY minus Total Rooms is less than or equal to 0, then you give me zero, if the date that is being filtered is less than today you also give me 0, but it gives me the subtraction Total Room SPLY minus Total Rooms

Let's see if anyone can help me.

Thank you

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Syndicate_Admin 

    You can refer to the following sample measure.

    Measure =
IF (
    OR (
        [Total Rooms SPLY] - [Total Rooms] <= 0,
        SELECTEDVALUE ( 'Table'[Date] ) < TODAY ()
    ),
    0,
    [Total Rooms SPLY] - [Total Rooms]
)

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.