Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating Headcount by Minute

Hello all! I am making a daily report for a short-term project that tracks (among other things) headcount in a secure area on a minute-by-basis, and I'm trying to create a line chart showing occup...
Need Help
Tutorial Requests
mh2587's avatar
mh2587
Super User
2 years ago
OccupancyMeasure = //Try this
SUMX (
    FILTER (
        'Trip Log',
        'Project Date/Time'[DateTime] >= 'Trip Log'[Time In]
        && 'Project Date/Time'[DateTime] < 'Trip Log'[Time Out]
    ),
    1
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Muhammad - Thanks for your reply! 
This doesn't work for me - It can't reference the date/time column and I get this error: 
A single value for column 'DateTime' in table 'Project Date/Time' cannot be determined. This can happen when a measure formula refers to a column that contains many values

Is this due to the relationship? My tables have a straightforward 1:* join: