DAX Measure - Row Level Security Issue

[Anonymous]

Hi 

I have a DAX measure that calculates the time an employee spend on a project as a percentage of their working week, which worked fine. However a new requirement has been introduced to restrict information some users see to just those projects they are working on, which I'm doing using Row Level Security. However by employing RLS it's obviously making the % calculation incorrect as the data is restricted to only one project so is returning 100% in each case.

I can't see a way round this and I'd appreciate any help or advice anyone could offer.

Thanks and regards

Corb

[Anonymous · Accepted solution]

I've managed to resolve this issue using the method in this article, by reloading a copy of the query and using this to calculate the denominator 

Calculating Total, and Percentages in a Row-Level Security Power BI Model - RADACAD