How to output all the names in a hierarchy using DAX? (Dynamic row level security for SSAS)

[techspert316]

Let me elaborate the question, I have a hierarchy column like this:

This is Analysis services.

As seen in the above picture 281 is the employee ID of the CEO and the rest employee IDs are his subordinates.

I want to implement Dynamic Row level security for organizational hierarchy in Analysis services.

so, for example employee id 290 logs in he should be able to see his data and his subordinates data.

please Help!

[djurecicK2]

Hi @techspert316 ,

 This article should point you in the right direction:

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

[techspert316]

thank you @djurecicK2  for replying

I tried this radacad post and it is not working in Analysis Services, please have a look