topic Related in Direct Query Mode in DAX Commands and Tips

Related in Direct Query Mode

RT6 — Wed, 30 Nov 2022 21:00:41 GMT

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 error:

Is there any work around to perform the calculation between two tables in the direct query mode?

Thanks!

Re: Related in Direct Query Mode

Anonymous — Thu, 01 Dec 2022 07:07:09 GMT

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.

Re: Related in Direct Query Mode

RT6 — Thu, 01 Dec 2022 08:04:46 GMT

Hi Alisa!

Thanks fro your answer.

The issue is after any transformation in Power Query, like split columns, change data type etc i get the following error:

I need to maintain Direct Query connection. I can aggregate two tables for example, but i cannot change data type even in PB Desktop, so i cannot perform any calculations.

Any ideas? Thanks!

Re: Related in Direct Query Mode

RT6 — Thu, 01 Dec 2022 08:40:08 GMT

What i also found in this paper, Related should be supported in DAX:

https://www.sqlbi.com/whitepapers/directquery-in-analysis-services-2016/

Re: Related in Direct Query Mode

Anonymous — Fri, 02 Dec 2022 02:09:32 GMT

Hi RT6

Did you use conditional formatting for your fields when your connection mode is Import ?

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.