Forum Discussion
Advocate IIFiltered row in data model for all tables joined
Hi All,
I have added a parameter and then applied it to a column to get my filtered rows. That works fine. In my data model EmployeeTable is joining on SalesTable with a unique EmployeeId. I am filtering EmployeeTable with a parameter value on the Department column. So give me all Employees in Outdoors (department). Again Filtered Rows works fine. I can get all employees with Outdoors department.
However, I expected the SalesTable to be filtered as well since they are joined in my data model. There is no department column in SalesTable only the EmployeeId which relates back to the EmployeeTable.
When I do a visualazation on the SalesTable I am seeing all Sales not just based on my filter (for Outdoors).
What am I missing?
Cheers, Scott
5 Replies
- Greg_Deckler
Community Champion
Please post a picture of your data model relationships if you can. I suspect that you need to configure the cross-filter direction on the relationships appropriately to achieve what you desire but I'd have to see the relationships first to confirm.
- wskallmeyer
Okay, this scenario is similar. I applied the parameter to filter the Tickets table to show only 1 department. 1 ticket will have mutiple metrics associated with it (eg, open, pending, close). I want the Metrics table to also be filtered down to the same department using the table relationship.
- wskallmeyer
I have also recently tried Cross Filter Direction: Both. And still the child table does not eliminate rows based on the filtered rows in the parent table.
I have also deleted the Filtered Rows step and then added it back to see if that would re-apply the filter. Without success.
Scott
