Forum Discussion

Krcmajster's avatar
Krcmajster
Icon for Helper IV rankHelper IV
5 years ago
Solved

RLS Rules

This might be a stupid question but it caused a bit of confusion in my team.  Some DAX functions have remarks that state: This function is not supported for use in DirectQuery mode when used in cal...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Krcmajster ,

     

    I have built a data sample for better understanding:

    ID is 5 = SUMX(FILTER(InternetSales, InternetSales[SalesTerritoryID]=5),[Freight])
    User is E = SUMX(FILTER(InternetSales, InternetSales[User]="E"),[Freight])

     

    RLS is used to restrict data access for given users. The DAX filter expression used for RLS should return a True/False value, so I created two roles:

     

    The final output is shown below:

     

    So based on my test, Import +SUMX() could works for RLS.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Krcmajster ,

 

I have built a data sample for better understanding:

ID is 5 = SUMX(FILTER(InternetSales, InternetSales[SalesTerritoryID]=5),[Freight])
User is E = SUMX(FILTER(InternetSales, InternetSales[User]="E"),[Freight])

 

RLS is used to restrict data access for given users. The DAX filter expression used for RLS should return a True/False value, so I created two roles:

 

The final output is shown below:

 

So based on my test, Import +SUMX() could works for RLS.

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.