Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Alina_Bd
Frequent Visitor

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

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
 
1 REPLY 1
Alina_Bd
Frequent Visitor

anyone?

I really need your help 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors