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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Since Your Geo table should be connected to both fact tables ,

 

1.  Remove the Join between Customer and Sales fact table 1

2. Copy Geo and Customer table using 'Reference' in Power Query and join Geo-> Customer-> Fact table 1.

 

So, in this case you will have the below joins:

 

Geo_copy -> Customer_Copy-> Facttable1

Geo -> Customer -> CRM Customer-> Facttable2

 

SInce you use 'Reference', Power BI will hit DB once and no performance issue as well.Hope this helps.

 

Thanks

Raj