Forum Discussion
Helper IIRelationships and Slicer
Community ChampionSo, if you create a DeptTable slicer and then add a table with "Payroll Transactions" and put the row_id column in it, I expect that the slicer filters that table, correct?
Now, if you add a table with "Payroll" table and put the row_id column in it, does that filter correct as well?
Helper IIYes Greg_Deckler those both filter correctly.
- Greg_Deckler
OK, so the next question is if you add the PayCodes table, does it filter correctly? I am assuming it doesn't but basically am trying to remove this from the realm of a DAX calculation and prove that it is entirely related to table relationships.
- Spencer
Sorry for taking your time but I have managed to solve the issue. I changed the relationship between my Payroll and Payroll Transactions to be row id to pfh_pay_date instead of rowid to rowid. It was actually an issue with the DateTable and not the DeptTable my apoligies.
The measures are slicing by both the Date and Dept now!
I did spot the problem when I went through your second question so thankyou very much for your assistance.
- Greg_Deckler
No problem, glad asking the dumb questions led to the solution!