Ambiguity problem multiple tables

[samc_26]

Hi all, so I've read multiple posts and watched multiple videos on how to sort this issue but I don't know how to apply the resolutions to my data. I'm trying to create a dashboard for multiple measures of chemical usage where you can select a site using a filter and all the different graphs for each measure will update. I can only get one to work at any one time which I know is due to the relationships being active or not. For some strange reason some will never work and some do if I make another relationship inactive. I've created a version of how my tables are set up at the moment and attached it below, there are 6 main tables in the centre of my file but I've only drawn in 3 for the purpose of asking the question as I figured any resolution would also be applicable for 6 tables. 

This is how my graph is constructed, the date is pulled from the 'Date' table and my page filter uses the site name from the 'Site table' which is just a list of all my sites in one single column.

This is driving me crazy so any help would be much appreciated! Thank you!

[Anonymous]

I think you'd better to consolidate the 3 fact tables into 1 since the data structure is exactly the same. You can do it in power Query by adding one column to store the type (1st/2nd/3rd). Then it will be pretty simple to create your charter. Otherwise you will have to put site asset into site table, and then link site table with fact tables by site + site asset, then you create 3 measures to calculate the value and put them into the same chart.

[samc_26]

Hi, thank you so much for taking the time to respond to me, I should have added that some of the values are % and the rest are decimal numbers so I don't think I can put them altogether 🤔

[amitchandak]

@samc_26 , You also need a common table site Asset

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

[samc_26]

Hi, so could you elaborate? I have 7 asset types and 13 sites - how would i structure the table please? Thank you