Distinct Count not working in DIRECT QUERY

Hi Anonymous ,

Please check the limitation of distinct count function in offical blog.

For reference: Remarks

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

If you use distinct count function in a measure, I think it will work.

Here is my test. Distinct count works in my measure.

Or you can try distinct count in value field.

Best Regards,
Rico Zhou

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