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.

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

Krcmajster ,You can create this like a measure.

= SUMX(FILTER(InternetSales, InternetSales[SalesTerritoryID]=5),[Freight])

 

There are a few limitations for what you can use in new column in Direct Query

  • Krcmajster's avatar
    Krcmajster
    Icon for Helper IV rankHelper IV
    4 years ago

    amitchandak Thanks for your answer. Direct Query is of no interset for me. My question is more about RLS. We have multiple clients in our database and we apply RLS based on client name in one table 
    Now, I want to use functions like SUMX or CROSSFilter in my  measures (I am not setting up RLS) but I am unsure if they will be impaceted by RLS.