Hi guys,
I have a measure where I want to calculate the amount of devices are more than 30 minutes (time colomn) active on a given day:
Occupancy =
CALCULATE(COUNT(Buildings[Device]); FILTER(Sensordata; Sensordata[time] >=30))
When I put a regular Calculate(count) of the devices in a visual and put a filter (time >=30) in the filter pane, the outcome is perfect. The right amount of devices is returned and when selecting a date in the table visual, all these devices are shown in another visual.
When I put in a filter in a measure (like the above code), the right amount of devices that have 30+ are returned as well, but also devices with <30 minutes are shown in a visual.
How is this possible?
