Row Seciurity Level

[Anonymous]

Hi, its my first time for using forum, i hope you can help me guys. I have a problem with makings indywidual row seciurity level for my report. I wanna show to defined RSL users values for whole company in total and details for theirs departments. Till now only way which works for now is when i use DAX filter [department] = "name of department" but this way doesn't show others data in total which i need to show them. I cannot do this in two different reports, they should have possibility to compare their departments on the total of company.

[nandic · Accepted solution]

Hi @Anonymous ,
Welcome to the forum.
Here was a topic with same issue, you could check it: https://community.powerbi.com/t5/Service/row-level-security-amp-overall-sum/td-p/63693 

Regards,
Nemanja Andic

[Anonymous]

Hi nandic,

Thanks for that, i didn't find this topic before, it's really helpful 🙂