Forum Discussion

Motwi's avatar
Motwi
Frequent Visitor
1 year ago
Solved

RLS table to filter multiple columns in the fact table

Hello everyone, I'm having a tough time trying to apply an RLS logic to filter two different things at the same time, please see below. I have a RLS table, that looks like this: User Regio...
data protection
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Motwi ,

     

    -- The function expects a table expression for argument
    Double-check that CALCULATETABLE is used here instead of CALCULATE. the former returns a table, while the latter returns a scalar.

    VAR __region = CALCULATETABLE(VALUES('dim_Regions'[Region]), 'RLS table'[User] == USERPRINCIPALNAME())

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Motwi ,

 

-- The function expects a table expression for argument
Double-check that CALCULATETABLE is used here instead of CALCULATE. the former returns a table, while the latter returns a scalar.

VAR __region = CALCULATETABLE(VALUES('dim_Regions'[Region]), 'RLS table'[User] == USERPRINCIPALNAME())

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Motwi's avatar
Motwi
Frequent Visitor
1 year ago

Hi,

 

It worked, thank you !

 

Apologies for the late reply, but I wasn't able to revisit this for a while

 

Best regards