Forum Discussion

nanma94's avatar
nanma94
Helper III
8 years ago

Data model question

      I have this simplified model (its a lot messier than this:) where on one report, geo country slicer drives visualizations that take measure from both measure tables down below, while on ...
Need Help
Thejeswar's avatar
Thejeswar
Super User
8 years ago

nanma94,

You can remove the join between Customer and Geo and Join Geo/Country with Sales. In that means, you can achieve a direct join between Geo and Sales.

 

You don't really need a join between your geo table and Customer Table unless you have a hirearchy of Geo and Customer.

 

If you really need a join between Geo and Customer, then keeping the join between them untouched, create an inactive relationship between your Geo and Sales Table based on your key.

 

Then when ever you are using a combination of these tables, you should create column/measure using USERELATIONSHIP() DAX Function

 

There's also another way to solve it. Just Duplicate you Geo table, and join the new Geo table with your Sales table. So in report where Geo table drives, use from the one that is not connected to the Customer and in report where Customer table drives, use the Geo table joined with the customer

 

Hope this clarifies your question!!!