topic Re: Using a hierarchy table without proper columns in a table as a measure in DAX Commands and Tips

Using a hierarchy table without proper columns in a table as a measure

ale_BI — Thu, 24 Nov 2022 10:12:01 GMT

I have a hierarchy tables of companies, and I need to use this to show in a table that certain companies are under others. The problem is that this hierarchy, as you can see below, has one column for father and child with distinct values, but only distinct values so I can't use the PATH function on it.

Now I have to make this table in my report:

Where, for example, Revenues is both a hierarchy father and has 3 children, and so on. I am completely lost as to how to write down this in a measure, can anyone help me out? The First table is connected to my Facts Table through a column that has all of the values for the codes present in 'root' and so on. The first table is just temporary, it will then be updated to include more data, but I thought I could at least try to get started on this

Re: Using a hierarchy table without proper columns in a table as a measure

NikhilChenna — Thu, 24 Nov 2022 10:19:11 GMT

Hi ale_BI , I think you can use a matrix table as a visual.
and drag root_desc in rows first and after the L1_desc second so the hirarchy comes properly.

Regards,
Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Re: Using a hierarchy table without proper columns in a table as a measure

ale_BI — Thu, 24 Nov 2022 13:33:28 GMT

I think that could work, but I am afraid I need to show more values at the bottom which I have in form of measures. So, ideally, I would put everything in a measure and then show it

Re: Using a hierarchy table without proper columns in a table as a measure

NikhilChenna — Thu, 24 Nov 2022 13:35:43 GMT

Hi ale_BI ,

You will be able to drag the measures only in the values part. So I think it should effect you. Try it out.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!