Slicer not properly filtering data

[alvarobrett]

Bad FilteringI'm building a dashboard with several reports comming from different SQL queries.

This data contains several values, and a few common ones like Location (e.g. London, New York), Country and Date.

I structured all tables to relating them separatelly (when applicable) to Location and Date. Then I've associated the Location to a Country source table.

All reports are working fine, but recently I've added one with service times for machines in these locations. And to my surprise the Slicers supposed to filter the locations and Countries, let some data in the report even after filtering both of them, as shown in the image. Coincidentally or not, all the not filtered results (red) have the same sum of time or quantity as the correct ones (green).

Do anyone have any idea?

[v-haibl-msft]

@alvarobrett

I'm a little confused about your issue. Do you mean that the green ones are filtered but the red ones are not filtered?

Do you have a sample pbix file which can be used to repro this issue? It seems that there are some unknown relationships in your model.

Best Regards,
Herbert