Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter applied on a Table is not taking effect on another table with relationship 'Many to One'

Hello, We Filtered out some ShopIDs from Shops Table (Screenshot)   as it is has stopped working from few months, say ID 4 and 5. We have got  several measures in the dataset for Employee count and many different criteria reporting of Employees and Administrators. Recently we could see that the ID’s filtered out in Shops Table is not taken effect in Employees Table and as the measures are just counting the Total number of Emplyoyees(Same rule is implemented in many measures), it counts the Employees from the Shop Id which is filtered as well. The Relationship between Employees Table to Shops Table is Many to One (Join on ShopID) and the crossfilter direction was single. I tried making it ‘Both’ but still the filter doesn’t apply on ‘Employees Table’. I am not able to use ‘Apply security filter in both directions as this warning pops up. Is there any simple way to achieve any filter changes applied on Shops Table  must take effect on ‘Employees Table as well, means those ID’s should get filtered out automatically from ‘Employees Table’. I understand adding a table in between with ShopID column and connecting the Id columns from bot table to this table would certainly solve the issue but as I mentioned it isa huge dataset and we have very less time to analyse the impact.

 


Any help is appreciated.

1 Reply