Forum Discussion

filiparibeiro's avatar
filiparibeiro
Helper III
4 years ago

Row Level Security and Sum Measure

Hi.

I'm experimenting with row level security (RLS). What happens is I have a table that has a client column and a revenue column and I want to apply RLS using the client's name. I'm trying to calculate the sum of the total revenue and this value should appear in a card visual, with the RLS applyed to a certain client.

I can obtain the value for a specific client but I can not obtain the total sum of all revenues.

How can I solve this situation whithout needing to add a new data source to the model?
And what else should I consider (limitations in RLS) when creating measures involving calculations whitin a table (such as total sum of values or ratio) ?

Thank you for your help!


Data Protection

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi filiparibeiro 

    The sole purpose of RLS when applied to a table is to restrict all rows of data which doesn't satisfy the logic used for it.

    Your ask is to unrestrict all rows of only one column without creating another table/dataset is kind of defys why RLS is created for.