Forum Discussion
Path function error
First off, there's a great blog post by the Italians on this topic here: Parent - Child Hierarchies. I've personally used their technique to successfully build a SSAS tab cube based upon essbase financial data with lots of ragged hierarchies.
Anyway, I believe I ran into this issue when I was building my cube. What I found was that there were "alternative hierarchies" in the base data that caused me to have duplicate "children." So in your application, I would examine your data. You likely have a member in the [person name] column that has multiple supervisors. Again, this may be because of an error in the base data and/or there's an alternative hierarchy listed in the data.
So I would go back to your query editor, remove duplicates from the [person name] column to test if your formulas will work then.
I have been trying to use the PATH function. I was not successful using my data so I created the same table shown on the www.daxpatterns.com/parent-child-hierarchies/. With the table and measure exactly the same as on the site, I still get an error in both PowerPivot and PowerBI. I then reproduced the sample that is shown on https://msdn.microsoft.com/en-us/library/gg492192.aspx, and still could not get the the path function to work.
Does anyone have any suggestion on where to go next?
I'm having the same issue - updated both Power BI and Excel 2016 - can't get PATH to work on either.
In Excel I get a vauge error related to missing ID that I'm certain are there - in Power BI I get an "unexpected error"
I'll test this on another machine tommorow but currently it's a dead end (been Googling for hours)