Forum Discussion

DeBIe's avatar
DeBIe
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

How to apply RLS and show blanks in table for specific measure?

Hi all,   I would like to return blank values or the value 0, based on the RLS role. Because some users are not allowed to see the processing time. I will explain the tables that are in my model an...
Need Help
  • DeBIe's avatar
    DeBIe
    3 years ago

    I've solved my issue by implementing Object Level Security and field parameters. This will remove the entire column which should not be visible for some users, but the table will not be broken.

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
3 years ago

Try to create a measure : 
Processed Time = IF(HASONEVALUE('ProcessingTime'[HasAccess]), 'ProcessingTime'[DocumentsProcessingTime], BLANK())

It will check if there is only one value for the 'ProcessingTime'[HasAccess] column which is determined by the RLS role, and if so, it returns the 'ProcessingTime'[DocumentsProcessingTime] value. Otherwise, it returns blank.

 

Then use it in your visual instead of directly referencing the 'ProcessingTime'[DocumentsProcessingTime] column.

 

And try to update the "Processed Time" measure to display 0 instead of blank:

Processed Time = IF(HASONEVALUE('ProcessingTime'[HasAccess]), 'ProcessingTime'[DocumentsProcessingTime], 0)

 

DeBIe's avatar
DeBIe
Icon for Post Partisan rankPost Partisan
3 years ago

Hi AmiraBedh ,

 

Thank you for your suggested solution. I have a question before I can try your formula.

 

My [Documents] Table contains more documents then in the related table [ProcessingTime] table. When I apply the RLS-Role (HasAccess=1), then the total count of my [Documents] table will be limited/filtered to the total that are found in the [ProcessingTime] table. I need to be able to find a solution for this first. Am I using this correctly? Please help.

 

Thanks so much already for your time.