Measure to override RLS using DAX

[nandic]

Hi,

I have dataset which has RLS.
Example, user John can see only data for Company A.
However, for specific benchmark measure, we would like to compare results of Company A vs average result of all companies in the same industry.
So user will not be able to see raw values for other companies, no access to raw data. User will only see the final aggregated result via measure.
I tried to use All(Table[Industry]) in a measure, but it doesn't work.

Adding calculated column is not an option as slicers have impact on calculation.

Disconnected tables can help, but i wanted to check if this can be completed only using DAX.

Thanks in advance!

Nemanja

[Anonymous]

Hi @nandic ,

Did @johnt75 reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

Best regards,

Adamk Kong

[johnt75]

Have a look at https://www.sqlbi.com/articles/computing-accurate-percentages-with-row-level-security-in-power-bi/