How to create a role for hiding some measures

[HTAHRI]

Hello, 

 I wanna create a role in PBI Desktop which will prohibiting users from seeing the values of somes measures:

For ex:

The role is R, I have a User U, and I have a table ( Col1, Col2,M1,M2), I want that when I affect the Role R to the user U, he cant show M1 so he can see all colomn (Col1,Col2) and M2 but the not value of M1.

In Role Manages I can't manipulate Measures

Somebody have the solution ?

Thank you

[v-huizhn-msft]

Hi @HTAHRI,

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data at the row level. The User U can't show M1, which should be column-level feature. Up to now, we have not column-level security feature in Power BI, we are unable to achieve your requirement. Please view this idea and vote it. 

Best Regards,
Angelia

[donsvensen]

Hi 

A workaround is described in my blogpost here - https://eriksvensen.wordpress.com/2018/03/03/hide-measures-using-row-level-security-powerbi/

Best regards

Erik

[Greg_Deckler]

RLS does not really work that way, you have to secure rows of data. Perhaps you could create a "junk" table that only factors into the calculation for M2. Essentially, I am thinking about an IF statement with a COUNTROWS of this junk table. So, if the COUNTROWS comes back blank, return M2 as BLANK, otherwise, do the calculation.