Forum Discussion
Solved
RLS with multi-tenant data and overall aggregates
Is this possible with Power BI? If I understand RLS correctly, all of my data has a tenant-id which I can use to filter by customer....So I can give customer 1 their data, customer 2 theirs but Nobo...
Hi horizondave,
I'm afraid this is restricted by the way how RLS works. Maybe you can add many attributes in one calculated table like this:
Table = ADDCOLUMNS ( { "Summarized Values" }, "Total Sales Quantity", SUM ( 'Sales'[Quantity] ), "Total Sales Amount", SUMX ( Sales, Sales[Net Price] * Sales[Quantity] ), "Number of kinds of Products", DISTINCTCOUNT ( 'Product'[Brand] ) )Best Regards!
Dale
The trouble is I potentially have *lots* of these attributes I want to add as averages....It's a very time consuming option to have to create each one individually.
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi horizondave,
I'm afraid this is restricted by the way how RLS works. Maybe you can add many attributes in one calculated table like this:
Table =
ADDCOLUMNS (
{ "Summarized Values" },
"Total Sales Quantity", SUM ( 'Sales'[Quantity] ),
"Total Sales Amount", SUMX ( Sales, Sales[Net Price] * Sales[Quantity] ),
"Number of kinds of Products", DISTINCTCOUNT ( 'Product'[Brand] )
)
Best Regards!
Dale
- v-jiascu-msft
I have accepted your answer as a potential solution, but my actual solution was to not use Power BI as it wasn't a good fit for my solution for other reasons.