Forum Discussion
Securing report values using a RACI Matrix
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
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.
3 Replies
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.Great work Sturla, I appreciate it so much
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.
