Relationships between multiple fact tables using conformed dimensions inactive relationships are for

[AbdulAzad]

Hi Guys,

I am pretty new to Power BI doing some POC on multi fact with conformed dimensions in Power BI, where I am creating two different reports from two different facts in two different pages, but using the same conformed dimensions. Here the issue I am facing is, I am not having an active relationship exist between the second fact and other conformed dimensions which are forming as inactive relationship, is it because the joins on conformed dimensions are on the same common columns? I have an active relationship on ITEM conformed dimension which is working as expected, but the chart from the chart is not working as expected? So I used the DAX fucntion to get the correct result in the chart, which show correct data, but filtering on the LOC slicer is not affecting on the chart visual?

Here is my model screenshot.

Can you guys please suggest any links, videos?

Your help is much appreciated.

Thanks & Regards,
A

[v-lili6-msft]

hi, @AbdulAzad

here are some blogs about modeling for you refer to:

https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/

https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/

https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Please understand that these link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Best Regards,

Lin