Help with new measure

[carly_030]

Is it possible for someone to tell me the measure I would need to calculate the available days for each month x rooms available e.g. Site C - October - 6 (rooms available) x  22 (Available days).  I want to be able to include this information within the top table but can't get it to split by month.  Hope this makes sense

[Anonymous · Accepted solution]

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.

[TomMartens]

Hey @carly_030 ,

without knowing anything about the underlying semantic model it's not possible.

Consider creating a pbix file that contains sample data but still reflects your semantic model (tables, relationships, columns, calculated columns, and measures). Upload the pbix file OneDrive, Google Drive, or Dropbox and share the link. If you are using a spreadsheet to create the sample data, share the spreadsheet as well.

Do not forget to describe the expected output.

Regards,

Tom