Forum Discussion
Solved
Reporting overall totals along with user specific data using row level security (RLS)
Greetings everyone, My office and I are new to Power BI and come from a SAS Visual Analytics environment. We are trying, most likely without spending the needed time watching videos and training ...
Noogin You could do that as well if you have a pre-aggregated table in your source. Otherwise, in Power Query reference your original query and then do a Group By step to aggregate the values. Or, just have one query and use a DAX calculated table using something like GROUPBY or SUMMARIZE to get the aggregates.
Greg_Deckler
Community Champion
Community ChampionNoogin Normally what you do in these types of situations is create an aggregation table. You can do this in Power Query Editor or with a DAX calculated table. This provides the aggregate values and is not subject to RLS. Then you have your main table that is affected by RLS for the individual reporting.