Forum Discussion

Noogin's avatar
Noogin
Frequent Visitor
3 years ago
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 ...
Higher Ed
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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.

Noogin's avatar
Noogin
Frequent Visitor
3 years ago

Thank you Greg_Deckler !

Just so I understand, you  do this using the Power Query Editor or with a DAX calculated table and not import an additional table with aggregated values?

Gary

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    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.