Combine RLS and hiding measure columns, work separately - not together

[Alina_Bd]

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

[Alina_Bd]

anyone?

I really need your help 🙂