Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I work in the healthcare field and created a dashboard that shows metrics like volume, revenue and others. We want to give each Provider access to this dashboard so they can see their own metrics. I created a RLS for each provider to filter the data on the name of the specific Provider. The issue I am having is we also want the dashboard to show the Max, Mean and Median for each of the metrics shown, across all providers. We want to use this as to tool to show the Providers how they are performing vs. other. When I created the RLS for a provider all of the metrics, including the Max, Mean and Median update to only show that provider (meaning the Max, Mean and Median are equal to the exact value of that specific provider). Is there a workaround for this so the Max, Median and Mean values still show for all of the providers, but the actual metric for that provider logged in only shows for them specifically?
Thanks, Kory
Solved! Go to Solution.
This post will probably help! https://community.powerbi.com/t5/Desktop/Row-level-security-ALL-function/m-p/586920
Please give it a thumbs up if this helps!
Thanks for this reference post! I think this should work. I'll work through adding this and update the group once completed.
This post will probably help! https://community.powerbi.com/t5/Desktop/Row-level-security-ALL-function/m-p/586920
Please give it a thumbs up if this helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |