cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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 my visual.

-I have 2 columns from 2 different tables.

Table 1 [Column Distance]

Table 2 [Column Flat Distance]

-I Need a new Column named [Total Distance]

So the Sum between Distance + Flat Distance.

Now i am, having the formula:

Totale Afstand = calculate(sum(Table 1[Distance])+sum(Table 2[Flat Distance]))

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 Number
No 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

Do you guys have an idea?

Thanks,

6 REPLIES 6
Anonymous
Not applicable

Good mornig,

Does somebody else, has any idea?

I'am stuck.

Gr,

Super User

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.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Anonymous
Not applicable

Hello Jihwan,

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

Is this the wright way?

Gr

Super User

Hi,

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Anonymous
Not applicable

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.

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.

Anonymous
Not applicable

Hi,

I hope this will work

https://1drv.ms/u/s!AtOPSsWoZPvOrU-GBG9Tt-eQvtuM?e=HjVxsz

Thank you.

Gr

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors