Forum Discussion
Ambiguity problem multiple tables
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 measu...
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.
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 🤔
