Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RELATED doesn't work for One-to-Many

Dear all,    I'm trying to lookup some values from anoter table but encountered with below error.    Dax used for the calculated column: Com = RELATED('Comissions&Margin'[Comissions])   Error M...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    v-lili6-msft, I have resolved this issue by changing the data connection to "Import"

     

    v-lili6-msft wrote:

    hi, Anonymous 

    This issue had been was reported to the product group before. ICM: 100120097

    PG team already created a bug item to track this issue. 

    PG team will try to add comments or a new article to clarify the related function work in certain scenarios.

     

    you could use the solution I had provided above for a substitution for now.  :smileyvery-happy:

     

    And could you please tell me if you have other problem? If not, could you please mark the helpful replies as Answered?

     

    Best Regards,

    Lin


    . Thank you. 

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

In my side, It works well. and if you could try this formula:

Column = CALCULATE(SUM('Comissions&Margin'[Comissions]),FILTER('Comissions&Margin','Comissions&Margin'[SalesCode]='Table'[SalesCode]))

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, v-lili6-msft , this could be helpful but I'm still clueless why it doesn't work for direct query for my case. 

 

v-lili6-msft wrote:

hi, Anonymous 

In my side, It works well. and if you could try this formula:

Column = CALCULATE(SUM('Comissions&Margin'[Comissions]),FILTER('Comissions&Margin','Comissions&Margin'[SalesCode]='Table'[SalesCode]))

Best Regards,

Lin

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    This issue had been was reported to the product group before. ICM: 100120097

    PG team already created a bug item to track this issue. 

    PG team will try to add comments or a new article to clarify the related function work in certain scenarios.

     

    you could use the solution I had provided above for a substitution for now.  :smileyvery-happy:

     

    And could you please tell me if you have other problem? If not, could you please mark the helpful replies as Answered?

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-lili6-msft, I have resolved this issue by changing the data connection to "Import"

       

      v-lili6-msft wrote:

      hi, Anonymous 

      This issue had been was reported to the product group before. ICM: 100120097

      PG team already created a bug item to track this issue. 

      PG team will try to add comments or a new article to clarify the related function work in certain scenarios.

       

      you could use the solution I had provided above for a substitution for now.  :smileyvery-happy:

       

      And could you please tell me if you have other problem? If not, could you please mark the helpful replies as Answered?

       

      Best Regards,

      Lin


      . Thank you. 

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        HI, Anonymous 

        Great!  Could you please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.  :smileyvery-happy:

         

        Best Regards,

        Lin