Forum Discussion
FILTER FLOW
Here I have created two tables, Supplier Table(Dimension Table) and Material Table(Fact Table).
Based on the filter flow the filter are flowing downwards. If I try to filter number of vendors per SPA using Vendor # from Material Table and SPA from Supplier Table, I get correct result.
HModel viewSPA from Material and Vendor # from SupplierSPA FROM Supplier and Vendor # from MaterialHowever, If I try to find Number of Vendors per SPA using Vendor # from Supplier Table and SPA from Material table, the data gets duplicated (Error). Is this because the filter is flowing downwards and filters from the lower table don't flow upwards?
Hello Bambroo69 ,
true, the arrow direction determines which table filters the other table, so if you got a field from a table that's against the flow then it won't filter it.
what you should do is use all the fields that you want to see the values with from the dimension tables and the values from the fact table.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
1 Reply
Hello Bambroo69 ,
true, the arrow direction determines which table filters the other table, so if you got a field from a table that's against the flow then it won't filter it.
what you should do is use all the fields that you want to see the values with from the dimension tables and the values from the fact table.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍