Help with new measure

Hi carly_030 ,

If I understand correctly, the issue is that you want to create the measure to calculate the available days. Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Create the new measure to calculate.

Available Room Days = 
var rooms = 
    SUMX(
        FILTER('Table room',
        'Table room'[Site] = "Ce" && 'Table room'[Month name] = "October" && 'Table room'[Rooms] = "Rooms available"
        ), 'Table room'[Available]
    )
var days = 
    SUMX(
        FILTER(
        'Table ava',
        'Table ava'[Month name] = "October" && 'Table ava'[Available] = "Available Days"
        ), 'Table ava'[Available Days]
    )
RETURN
    CALCULATE(rooms * days)
    

3.Drag the measure into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

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