Summarize problems

Question

Hello all,&nbsp;I am having again an issue, probably pretty simple.&nbsp;I need the sum of 2 different columns from 2 different tables.Tried different options, but i won't get the wright solution in my visual.&nbsp;-I have 2 columns from 2 different tables.Table 1&nbsp;[Column Distance]Table 2 [Column Flat Distance]&nbsp;-I Need a new Column named [Total Distance]So the Sum between Distance + Flat Distance.&nbsp;Now i am, having the formula:Totale Afstand = calculate(sum(Table 1[Distance])+sum(Table 2[Flat Distance]))&nbsp;But my result looks like a summup of all the numbers of this column Total Distance.From al the Columns is the Data Type = Whole NumberNo summarize&nbsp;Table 1&nbsp;Table 2&nbsp;Expected&nbsp;Result nowDistance&nbsp;DIstance Flat100&nbsp;25&nbsp;125&nbsp;951669150&nbsp;5&nbsp;155&nbsp;951669100&nbsp;75&nbsp;175&nbsp;951669200&nbsp;100&nbsp;300&nbsp;951669185&nbsp;20&nbsp;205&nbsp;951669200&nbsp;50&nbsp;250&nbsp;951669250&nbsp;75&nbsp;325&nbsp;951669&nbsp;&nbsp;Do you guys have an idea?&nbsp;&nbsp;Thanks,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

jihwan_kim · Answer

Hi,
I am not sure how your datamodel looks like, but if you are looking for creating a new table, please check the below picture and the attached pbix file.
&nbsp;

&nbsp;
&nbsp;
&nbsp;

&nbsp;
New Table = 
SUMMARIZE (
    ADDCOLUMNS (
        GENERATE ( Table1, FILTER ( Table2, Table2[ID] = Table1[ID] ) ),
        "@Total Distance", Table1[Distance] + Table2[Distance Flat]
    ),
    Table1[Distance],
    Table2[Distance Flat],
    [@Total Distance]
)
&nbsp;

anonymous · Answer

Hello Jihwan,&nbsp;Thank you for your response.&nbsp;Unforunatly i becom an error when i will use your text:&nbsp;&nbsp;I added a newe column and putted your text in here.&nbsp;Is this the wright way?&nbsp;&nbsp;Gr

jihwan_kim · Answer

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 · Answer

Hello,&nbsp;Also with a new Table, i become this error.&nbsp;&nbsp;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.&nbsp;&nbsp;In this file your code is working, but the outcome in my visual is still the sum of al values together.&nbsp;&nbsp;When i change this to "don't summarize" i become below error.&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi,&nbsp;I hope this will work&nbsp;https://1drv.ms/u/s!AtOPSsWoZPvOrU-GBG9Tt-eQvtuM?e=HjVxsz&nbsp;&nbsp;Thank you.&nbsp;Gr&nbsp;

Forum Discussion

Summarize problems

6 Replies

Related content

Parameter in summarize

Don't Summarize....still summarizes...?

Logic problem?

summarize and selectcolumns problems

GroupBY and summarize

Table 1	Table 2	Expected	Result now
Distance	DIstance Flat
100	25	125	951669
150	5	155	951669
100	75	175	951669
200	100	300	951669
185	20	205	951669
200	50	250	951669
250	75	325	951669