Forum Discussion
Help understanding the relationships between tables
You can use Performance Analyzer to get the actual DAX query generated for each visual. Copy the queries for both the visuals you are interested in and paste them into DAX Studio. You can then see exactly which filters are being applied to each visual and it should help you work out why one is returning more rows than the other.
johnt75 Thank you. I dont THINK this is doing it though, I may be doing something wrong. What I mean is that I BELIEVE my slicers are already synced across all three tabs:
And if I go look at the table on the third tab, it says a bunch of slicers are currently affecting it:
(I changed the slicer values between taking these screenshots, dates look different in each)
BUT on the first tab I've filtered it so strictly that only 5 people are coming in over the next two days, but on the third tab it still shows all 30+ people.
You can use Performance Analyzer to get the actual DAX query generated for each visual. Copy the queries for both the visuals you are interested in and paste them into DAX Studio. You can then see exactly which filters are being applied to each visual and it should help you work out why one is returning more rows than the other.