Forum Discussion
Power BI Embedded and multitenant support
What I would recommend would be to do another import of your data but summarize the data in Power Query such that all of the details are removed and then base your measure calculation (if needed) on that table. So, for example, you could do a "Group By" in Power Query to remove row level detail. Then, give everyone access to that table in RLS, or portions of the table that are relevant. For example, if you summarize by industry and only want them to see the measure calculated by their particular industry.
What I would recommend would be to do another import of your data but summarize the data in Power Query such that all of the details are removed and then base your measure calculation (if needed) on that table. So, for example, you could do a "Group By" in Power Query to remove row level detail. Then, give everyone access to that table in RLS, or portions of the table that are relevant. For example, if you summarize by industry and only want them to see the measure calculated by their particular industry.
Thanks for this suggestion Greg_Deckler. I'd got to the point of realizing that RLS "pre"-filters the data before the ALL function in my DAX expressions even applies, but didn't have a solution. Your idea worked fine for my use case: RLS roles ensure that our users only see performance data for their specific states and sites (using on Security Groups and UserPrincipalName()), but we want to show "program-wide" values so they can compare performance in their area to program-wide averages. Obviously ALL wasn't working because the rest of the program was (rightly) filtered out for them.