Forum Discussion

mossshvlw's avatar
mossshvlw
Helper II
5 years ago
Solved

Using a card visualization with if/else statement

Hi all.   I have a card on a power bi report that I want to update based on row-level-security (RLS).  The RLS is set up to filter my data on the field "county."  Each RLS role only displays data f...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    mossshvlw yes because when RLS is applied it is not seeing that table isfiltered even thru RLS it is filtered as one country

     

    change ISFILTERED To HASONEVALUE

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
5 years ago

mossshvlw yes because when RLS is applied it is not seeing that table isfiltered even thru RLS it is filtered as one country

 

change ISFILTERED To HASONEVALUE

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

mossshvlw's avatar
mossshvlw
Helper II
5 years ago

Thanks.  This worked, but what exactly is RLS doing then?  Is RLS actually filtering the table?