Securing report values using a RACI Matrix

[y5famfnatudu]

Hello,

Is it possible to hide/show Revenue based on a RACI Matrix that is added to the data model?

The scenario is as follows:

The above RACI Matrix indicates [who] is supposed to access [what] per each [customer]

CustomerCode[0] = ALL Customers

CustomerCode[Any other value] = Indicates a specific customer

Revenue[1] = Employee is allowed access to revenue values

Revenue[0] = Employee is not allowed access

Your help is so much appreciated.

Best regards,

Simon

[sturlaws · Accepted solution]

Hi, @y5famfnatudu,

based on the information you provided, I have createt an example on how this can be solved, attached at the bottom of this post.

In general, you should look into dynamic row level security, using the DAX-function Userprinicipalname to detect the viewer of the report.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[y5famfnatudu]

Dear @sturlaws,

I have a question please.

In the screenshot attached, is there anyway to see the CustomerID, and the remaining COLUMNS, but hide the REVENUE

So, instead of seeing the following:

See:

where Product and Quantity are existing in the same Table where Revenue is calculated.

[y5famfnatudu]

Great work Sturla, I appreciate it so much