Forum Discussion
Filter Data | Between dimension tables
Hi there, I have an issue of filtering data between master tables. For an instance, there is a relationship between sales, organization table, and product table. when I filter the organization, t...
You need a many side table to remove the ambiguity. It seems all tables are having unique values, in this case you could just merge the 3 tables into 1 table.
Organisation Id, Product ID, Name, Value, Product name.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Like the sales fact table, the power bi file has purchase, profit, and many more table related products and organisation. Hence, it's not the right way to merge fact tables with dimension tables.