Forum Discussion
Data model help
What did you try?
I'd guess you have to create a table with unique campaign values, then make a one sided relationship from that to the other tables. In power query, you can just right click a column name and choose "Remove Duplicates".
I did this, however then i also had the "order" table. Also connected to all the tables.
I want both the campaign and the order table to filter eachother, so when a user selects a campaign, the list of orders updates. To do that i thought i needed a two directional relationship, so that campaign will filter my data tables, which will then filter the order table, and vice versa.
However, when i tried to do this Powerbi wouldn't let me, think it has something to do with data ambiguity and so on. Basically once i tried creating a 2 directional filter relationship with the data tables and the order table, after having done the same with the campaign and data tables, it wouldn't let me.