Forum Discussion
Use filter but avoid propoagation effect
I created a new AllDates(id, date) table with 1:* relationship with Tornado and 'public employee_schedule' on date column.
In my page, I use AllDates.date for filtering, which propagates to both Tornado and public 'public employee_schedule'.
Finally I use Format > Edit Interactions to avoid any other unwanted filters/slicers affecting my measure (that is shown in a KPI card).
Thanks guys for the help.
Check the filter options for the relationship between WorkDone and your Employee table.
The default behavior (filter goes bothways) can be changed when you edit the relationship.
The cross table direction is already set to single, and btw, i do need filters to propagate for other parts of the page; it's just the measure calculation that is an exception.
Can you post a screenshot of your model?
DB Schema. 'Tornado' is the table that records hours spent. employee_schedule is the table that records available hours per day per employee.