Row sum in matrix with boolean value

Hi, Anonymous ;

According to the official document, This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. 

There is no mention of the restrictions in SSAS, maybe because of the version, you can try to update the version of the desktop. In addition, I tested it with SSAS and it was ok.

 

Secondly, you can also use HASONEVALUE or ISFILTERED functions to replace ISINSCOPE function , Another point is to create measure instead of column.

Or can you share me Screenshot of the error message.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.