Forum Discussion
Matrix with multiple hierarchy
Hello, I have a table that contains father_code and for each one of them there is a son code(it's like category and subcategory). In parallel with, i have a corresponding label that corresponds ...
Hey salemhaddad,
Look into the PATH DAX function. Here's a link to some documentation. It seems to be exactly what you need.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
It works by putting it as column and not a measure.
Thank you very much.
Thank you very much for the recommandation.
I tried to use it:
DEFINE
VAR path_column = PATH(table[Son_code], table[Father_code])
EVALUATE
SELECTCOLUMNS(table,table[Son_code], table[Father_code], )
"path_column", path_column
It give an error: A table of multiple values was supplied where a single value was expected.