Hello All,
I have created a report for the PM level.
I have created a role as PM in desktop and used USENAME() dax funciton and i have published thos report to the serivce level.
There i have added respective people who have access to this report.
And it is working fine.
Currently i have created only single role that is PM.
But now i have another 2 senarions.
1:-- For some people this report should be filtered by the SBU wise.
At PM level the projects will be filtered by the peoject list which a perticular PM is having under his list.
But there are some users, for them the same report shoud be filtered as
all the projects which the perticular user belongs to the perticular SBU.
2:--- For some peopel this report should be filtered by the DM level.
like as PM, how the project are getting filtered.
For DM also it should be filtered all the projects under him.
A-->PM--> PID-1,PID-2 PID-3
B-->PM--> PID-4,PID-5 PID-6
C--> DM--> under him A and B PM's are there. So here the project list should be
PID-1,PID-2 PID-3,PID-4,PID-5 PID-6
Is it possible with current powerbi RLS.
Any suggestions.
Thanks,
Mohan V
