Forum Discussion
Anonymous
6 years agoNot applicable
Calculation for all but selected value using row level security
I am implementing row level security on a data model that includes aggregate tables. I am using the aggregate tables to report the totals for my organization. However, I also want to show a rate for ...
v-joesh-msft
6 years agoSolution Sage
Hi Anonymous ,
As this post says:
"The only solution to the problem is to create static measures or a separate table where you hold certain, company-wide metrics/aggregations/calculations. This separate table should not be tied to RLS and then you can use the aggregated metrics in that table in your calculations. "
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.