Manage Roles / Users can STILL see the measures, even if I've hid the entire table

[AliceW]

Hi team,

Am I doing something wrong?

I've created a Role called 'Everyone Else' in Desktop. For each table, i've put 'false' in the 'Table filter DAX expression.

Then, in the Service version, I've allocated users to this role.

They can see blanks when it comes to COLUMNS, but they can still see the MEASURES.

Which defeats the purpose...

Am I doing something wrong?

Please help, as this is quite urgent.

Thanks,

Alice

[Seth_C_Bauer]

@AliceW What is it you are trying to accomplish? RLS is for data, not hiding objects in the report (Tables, columns, measures)

[AliceW]

Hi @Seth_C_Bauer 

I need a report with Sales Targets per Rep. Published in an App (they have Premium licenses).

Goal: some people to see the targets and how much they've accomplished AND the rest of the folks members in the App to see, well, blanks.

I thought it was possible after reading https://docs.microsoft.com/en-us/power-bi/desktop-rls

😞

Alice

[Seth_C_Bauer]

@AliceW Does it filter appropriately when you test it out under the "View as Roles" in the Desktop?

How are you sharing the report to the end users, are they members of the workspace?

[AliceW]

It tests appropriately when it comes to columns (the visuals in the report containing column data are blanked, and only the column names are in).

However, I have this Card with a Measure and, alas, the Measure is visible.

I published the report in the App. There, there are around 30 users, and I only want 5 of them to see the measures and columns...

[AliceW]

Update: a measure with CALCULATE(DISTINCT COUNT....) is blanked out - hurray (call it CONTRACT COUNT).

The problem is another measure based on this one. This one is an IF one

PAY = IF([CONTRACT COUNT] = 1, 100, 300).

Is there a way to rewrite this, please?

[AliceW · Accepted solution]

Figured it out with a colleague.

The trick is to build the IF measure with a blank as a first condition.

VALUE =

IF (MEASURE=0, "",

IF(MEASURE <10, 100,

etc.

The logic is that, for those roles, the rows will be zero, so the MEASURE will be zero too.