Forum Discussion

JoeCrozier's avatar
JoeCrozier
Helper II
3 years ago
Solved

Help understanding the relationships between tables

I apologize because I'm sure some version of this question has been asked, but I'm having the hardest time with it.   I have a report like this:     It's got three tabs, based on three sep...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

JoeCrozier See if you can post an image of your data model and explain where your slicer value are coming from and where your values are coming from.

  • JoeCrozier's avatar
    JoeCrozier
    Helper II
    3 years ago

    Greg_Deckler   Thank you for the prompt response.

     

    Here is a photo of the model: 

     

    What I'd done so far (for the first two tabs), is just open the "staff" query, merge in the subjects query so its one giant dataset, and then for every slicer/table/card on the first two tabs use a variable from the new bigger "staff" query.