Hello everyone! I have an issue with defining roles for directors of business units in my company and at the same time illustrating in visualizations average values throughout the company for comparison. Power BI applies the role also for the average value so it becomes an equal for the value of the current business unit. Does the Power BI provides any opportunities to realize both role and average meaning? I will be very greatful for help!
Your requirement is not very clear. Show us a complete example, please.
That's what RLS does. It restricts data access for given users.
It restricts data at the row level. The total number of rows is reduced.