Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Summarize problems

Hello all,   I am having again an issue, probably pretty simple.   I need the sum of 2 different columns from 2 different tables. Tried different options, but i won't get the wright solution in ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Jihwan,

 

Thank you for your response.

 

Unforunatly i becom an error when i will use your text:

 

 

I added a newe column and putted your text in here.

 

Is this the wright way?

 

 

Gr

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Thank you for your message.

I am not sure how to check it without seeing your datamodel, but I see that you put that as a calculated column. My DAX formula is for creating a table, not a column.

Please share your sample pbix file's link, and then I can try to look into it to come up with a solution.

Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello,

     

    Also with a new Table, i become this error.

     

     

    Attach you will find my dummy "Distance"PBIX file, with the same settings and relationship.

    Sorry, i will find out now how to share this link.

     

     

    In this file your code is working, but the outcome in my visual is still the sum of al values together.

     

     

    When i change this to "don't summarize" i become below error.