Forum Discussion
PowerBi Cross Filteration without Relationship
Anonymous , I think you need to try role playing dimension
Dear, Thanks for your time
The method of Role-Playing Dimension has the same effect as the previous. Suppose, I have Sales Info table and Purchase Return Table, both have same field of Customer & Sales Person, but in between is Sales Officer table with active relationship on Sales Person field in both Sales and Purchase Return table. On report, I have two table to show, one is sales and another is purchase, here say I want to select customer in Sales table and I want to see same customer records in Purchase Return table which in practical I'm not getting. Here if I select customer from Sales table, I will get all customer under selected customer's Sales Person because actual relationship is on Sales Person.
It is to let you know the PowerBi Desktop I'm using doesn't support Many to Many relationship "maybe".