Forum Discussion

horizondave's avatar
horizondave
Regular Visitor
8 years ago
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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi horizondave,

 

The solution could be that you can add the Overall as a calculated column. Or create a summarized table.  You can try it out. 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

 

horizondave's avatar
horizondave
Regular Visitor
8 years ago

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's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi horizondave,

       

      Could you please mark a answer for this thread?

       

      Best Regards,

      Dale

      • horizondave's avatar
        horizondave
        Regular Visitor
        8 years ago

        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.