I would like to ask for your help:
I have a report where I have one RLS role with below filter:
email = USERPRINCIPALNAME()
This is a complex role in behing which is working fine;
Now I would like to add a hiding measures for some of users - separatly both working super, however I'm not able to combne them.
This is excample of measure:
sum('table'[Amount (LC)]) * [RLS_Measure]
And my helping measure is:
RLS_Measure = LOOKUPVALUE(
User[ShowMeasures], User[e-mail adress]
Show measure is 1 or 0, Excample:
If I'm trying to combine RSL stopped working - but measures are hide correctly.
Any idea how to adjut?
Let me know if futher details needed?