Forum Discussion
Helper III3 Table Relationship Question
The solution was to create a bridge table. See below:
Helper IIIThanks for the suggestion; I tried this but was still given the similar ambiguity error when trying to connect the Commission and Campaign tables.
Super UserAh, you're right. You would still have multiple paths for Date to filter the other tables: either directly e.g. Date --> Commission or indirectly e.g. Date --> Campaign --> Commission.
I think the problem boils down to having Date serving two different purposes simultaneously. You probably don't actually want Date to filter campaign date creation and invoice date simultaneously (you'd only see situations where both of those dates are the same), so one of those relationships should probably be inactive or else you might want separate date tables.
Further reading:
https://www.sqlbi.com/articles/using-cross-highlight-with-order-and-delivery-dates-in-power-bi/
- shaebert
Actually Yes I want to simultaneously show the number of campaigns separate from the sum of commission that were generated in the timeframe selected from the date table. I don't want the commission amount to be dependent on the campaign or vice versa. Maybe creating two date tables well accomplish my goal.