Hi,
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:
Amount_LCMeasure =
if([RLS_Measure]=0 ,
BLANK(),
sum('table'[Amount (LC)]) * [RLS_Measure]
)
And my helping measure is:
RLS_Measure = LOOKUPVALUE(
User[ShowMeasures], User[e-mail adress]
, USERPRINCIPALNAME()
)
Show measure is 1 or 0, Excample:
joe@com 1
david@com 0
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?
Thanks
