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