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 try to build a PATH based upon a parent child hierachy wich isn't totally clean. After a couple of fixes, I'm currently stuck here:
The error says I have multiple value for 045444 but I don't see where... Filter 1) if set on MasterItem.
And here is the result for filter on child id:
So I understand, that the function has an issue with the fact, that the child can appear in multiple masters... how should this be solved as best practice?
Thanks in advance Philipp
Solved! Go to Solution.
Hello,
The Why part is explained in the definition of Path function:
"If ID_columnName has duplicates and parent_columnName is the same for those duplicates then PATH() returns the common parent_columnName value; however, if parent_columnNamevalue is different for those duplicates then PATH() returns an error. In other words, if you have two listings for the same employee ID and they have the same manager ID, the PATH function returns the ID for that manager. However, if there are two identical employee IDs that have different manager IDs, the PATH function returns an error."
Extract taken from the definition of the function:
https://docs.microsoft.com/en-us/dax/path-function-dax
Some of the ways to solve this would be:
- ImkeF's blog posts (Power Query):
- DAX:
https://powerpivotpro.com/2018/09/using-dax-to-handle-multiple-parent-hierarchies/
Regards,
ElenaN
Hello,
The Why part is explained in the definition of Path function:
"If ID_columnName has duplicates and parent_columnName is the same for those duplicates then PATH() returns the common parent_columnName value; however, if parent_columnNamevalue is different for those duplicates then PATH() returns an error. In other words, if you have two listings for the same employee ID and they have the same manager ID, the PATH function returns the ID for that manager. However, if there are two identical employee IDs that have different manager IDs, the PATH function returns an error."
Extract taken from the definition of the function:
https://docs.microsoft.com/en-us/dax/path-function-dax
Some of the ways to solve this would be:
- ImkeF's blog posts (Power Query):
- DAX:
https://powerpivotpro.com/2018/09/using-dax-to-handle-multiple-parent-hierarchies/
Regards,
ElenaN
Hi ElenaN,
thanks for your support, I'll check the links which seem to be promising and let you know later if it works out 😉
Cheers Philipp
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |