Forum Discussion

RT6's avatar
RT6
Frequent Visitor
3 years ago

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

 

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

 

Thanks!

 

 

DAX
Direct Query
related

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

    • RT6's avatar
      RT6
      Frequent Visitor
      3 years ago

      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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.