Calculate filter not working correctly

[Anonymous]

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?

[v-yuta-msft]

@Anonymous ,

I couldn't reproduce your issue, the visual will be filtered on my side. I guess this issue should be related to your data. Could you share sample data of table "Buildings" and "Sensordata" for further test? (please do not post the original data)

Regards,

Jimmy Tao