Creating a visual to display the occupancy in a car park

[Melissa]

Okay I’m on the latest version of PBI, expect it’s related to this thread.

DAX | CALCULATE | March' 2021 Update

Effective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the equivalent expanded version. Earlier you had to write: Red Contoso = CALCULATE ( [Total Sales], Products[Color] = "Red", Products[Brand] = "Contoso" ) Because Products[Color] = “Red” and Products[Brand] = “Contoso” internally expands to the below version, therefore they couldn’t be combined into one filter (row context mapping issue): FILTER ( AL…

Try again but instead of the && use a comma like below

Occupancy = 
VAR TimeSelection = SELECTEDVALUE( Data_Sample[Purchase Start Date & Time] )
RETURN

COUNTROWS( 
    CALCULATETABLE( Data_Sample,
        REMOVEFILTERS( Data_Sample[Purchase Start Date & Time] ),
        Data_Sample[Purchase Start Date & Time] <= TimeSelection,
        Data_Sample[Purchase End Date & Time] >= TimeSelection
    )
)