Forum Discussion
Ambiguous paths when linking to date table / How to count rows containing a particular value
Hi swisdom
Are you able to share a screenshot of your Model / Relationships view? It is very likely the error is stemming from established relationships.
Also, in terms of the grouping, you can use "Conditional Columns" in Power Query which reduces the volume of measures that you require and will achieve the same outcome. Let me know if you'd like me to run you through simple steps for this 🙂
Theo
I am actually not able to edit the dataset/columns in PowerQuery, as it is linked from an outside source via DirectQuery. This is why I am using Measures for all the calculations 🙂
This is the portion of the model linking the data table in question to the Date table, with the active link highlighted. (The others are inactive links to other dates in the table for other calculations using [USERELATIONSHIP] later, though they are not set up yet.)
The Date table also links to the Shipping dataset just above it in the same way. There are also links to other reference tables (customer, failure type, location, etc) but nothing that is causing circular logic that I can see.
swisdom thank you for sharing. It's really interesting. I am unsure to be honest. Although a clear solution has been provided to get you the outcome required, I am interested to better understand the cause of the error otherwise, as you expand / enhance your report, there is a potential likelihood that it may repeat itself if not identified / corrected.