Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm kind of mind boggled. I have a major table: DEVPROT_MASTER2 that I'm trying to connect to differerent tables, and perform calculations.
In the first scenario I would like to perform a calculation based on YYYYMM and segment. Hence I created 2 reference tables of that sort and connected my DEVPROT_MASTER2 table and my HUP table to them, all Single filters going from the reference tables to the core tables.
In my second scenario, I do the same thing. I clone my 2 reference tables and to avoid errors, I import the DEVPROT_MASTER2 table again to do a separate calculation with the EBU_NAC table.
However when I try to make the last relationship join I receive the following error.
'There are ambiguous paths between 'EBU_NAC' and 'SegmentTable (2): 'EBU_NAC'->'MonthTable2'->'DEVPROT_MASTER2 (2)'->'SegmentTable (2)' and 'EBU_NAC'->'SegmentTable (2)'
How is that possible when I just did the same exact joins with the same exact reference tables in Scenario 1?
All the relationships are set many to many and all the tables are connected. So if you filter on Segment in your scenario 1 there are two paths to get to your Month table, that's why its ambiguous. And that is also why your scenario 2 works. Try changing your Month and Segment tables to 1:M to each of the other tables, as month and segment appear to be dimension tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
88 | |
75 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |