Forum Discussion

Krcmajster's avatar
Krcmajster
Icon for Helper IV rankHelper IV
4 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
    4 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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Is this any better?

=calculate([freight],InternetSales[SalesTerritoryID]=5)