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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.