Forum Discussion
Securing report values using a RACI Matrix
- 3 years ago
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.
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.
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.