how do you use the DAX hierarchy in the report view

[alexkelly101757]

Hello, how do you use the DAX hierarchy in the report view? I've created a 4 level hierarchy using DAX and was expecting to be able to drag this into a report but it doesnt show in the report view.

Thanks 

[v-jiascu-msft]

Hi @alexkelly101757 ,

Can you share the code of the DAX? Please mask the sensitive parts. If you'd like to use it in a visual as context, you need to create a calculated column or a table. I'm afraid you can't use it as a hierarchy if you created a measure. 

Best Regards,