Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

EXCEPT function not working as expected

Hi,   I am trying to show a table with Corporate Units and Locations to which the user does not have access to, called Access. Corporate Units and Locations are dimensions that have DLRS (Dynamic r...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    After my continuous testing, due to the DAX restrictions in DirectQuery, I did not find a replacement function. It is recommended that you replace the connection mode with the import mode.

     

     

    Best Regards,

    Stephen Tao

     

    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 Anonymous ,

 

EXCEPT function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

 

Reference: https://docs.microsoft.com/en-us/dax/except-function-dax#remarks

 

 

 

Best Regards,

Stephen Tao

 

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 Stephen,

 

Thank you for your answer. What alternative could I use to get the desired result?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    After my continuous testing, due to the DAX restrictions in DirectQuery, I did not find a replacement function. It is recommended that you replace the connection mode with the import mode.

     

     

    Best Regards,

    Stephen Tao

     

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