Forum Discussion

nlefalher's avatar
nlefalher
Frequent Visitor
6 years ago
Solved

Manage roles : hide a column with value

Hello,   I would like to know how to hide all values from a column but i want to keep the other columns.   Here a exemple table :   Region ||  Production || Time || Turn over North   || 1500  ...
data protection
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi nlefalher, 

    I think RLS will hide the row instead of change the row value. So if you want to change cell value to 0 , you could try to use measure to achieve this. You could create table like below

    Then create relationship like below

    Try below measure

    Measure 2 = IF(USERPRINCIPALNAME() IN VALUES('Table (2)'[name]), CALCULATE( SUM('Table'[ Turn over]), FILTER('Table','Table'[Region ]<>MIN('Table (2)'[Region])))+0,( SUM('Table'[ Turn over])))

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi nlefalher, 

I think RLS will hide the row instead of change the row value. So if you want to change cell value to 0 , you could try to use measure to achieve this. You could create table like below

Then create relationship like below

Try below measure

Measure 2 = IF(USERPRINCIPALNAME() IN VALUES('Table (2)'[name]), CALCULATE( SUM('Table'[ Turn over]), FILTER('Table','Table'[Region ]<>MIN('Table (2)'[Region])))+0,( SUM('Table'[ Turn over])))

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nlefalher's avatar
nlefalher
Frequent Visitor
6 years ago

Hello,

 

So I worked on it, I simplify as much as I can to achieve it. I kept my SNL because i got at least 20 roles already done.

 

Measure 2 = IF(USERPRINCIPALNAME(REV-Emmanuel_BERTHIER);calcuLATE( sum('zsaisieent'[CA])),0)

My exemple was on my colleague Mr BERTHIER, with this formula he cannot see any turnover and with the SNL system he can only see data on his region.

 

Really thank you to open my mind to find a solution of my issue.

 

Best regards !