DAX hierarchy question

dhbhojwa — Sat, 23 Jun 2018 12:58:05 GMT

We have a requirement where when the user logs into powerBi he should be able to see all his direct reportees and indirect reportees based on the slicer.

So there will be a slicer having two options. 1st option will be direct reportees and 2. indirect reportees.

By clicking the 1st option the user should be able to see all the direct reportees and by clicking on th 2nd option he should be able to see all the indirect reportees.

The SQL table has two columns, having the childId and parentId.

There will be multiple user like this who logs in and they should be able to see there direct and indirect reportees.

Is this scenario possible using the powerBi ?

Need help.

Thanks in advance.

Re: DAX hierarchy question

v-jiascu-msft — Tue, 26 Jun 2018 07:21:37 GMT

Hi dhbhojwa,

Can you share a sample of you data? Did the slicer and a table visual work?

Best Regards,

Dale

topic DAX hierarchy question in Developer

DAX hierarchy question

Re: DAX hierarchy question