HELP WITH A MEASURE

[Syndicate_Admin]

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

[v-xinruzhu-msft]

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.