Does anyone know what DAX measures are needed to allow RLS security to be ignored.
I’ve implemented RLS successfully but would like the end users to be able to compare themselves against the rest of the organisation.
I’ve tried wrapping the orginal measure with a ALL and ALLEXCEPT but when i drill through the data the results from the measure does not change.
= calculate(([NN] + [SN] + [MN] + [ND] + [SD] + [MD]) / sum(Fact_Sickness[WD]),(‘Fact_Sickness’))
Wrapped DAX to attempt to ignore RLS
= calculate(([NN] + [SN] + [MN] + [ND] + [SD] + [MD]) / sum(Fact_Sickness[WD]),ALL(‘Dim_Team Hierarchy’),all(‘Fact_Sickness’)
The measures I’m measure branching of are just countrows using filter.
Any help would be appreciated.