Forum Discussion
Related in Direct Query Mode
Hello! I am trying to do basic calculation Related in the Direct Query mode: Sales Amount = RELATED('product'[Unit_Price]) * sales_streaming[Units] and i get the following er...
Hi RT6
This error is thrown when some aggregation (in this case the count) is been translated to M for execution, so it's not really SQL yet . You can check your query in Power Query Editor to see whether some queries affect your operation .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What i also found in this paper, Related should be supported in DAX:
https://www.sqlbi.com/whitepapers/directquery-in-analysis-services-2016/