Grouping data in different columns

[Anonymous]

I have a set of data which looks like the below: 

Order Number	Amount 1	Amount 2	Amount 3	Amount 4
1	138	null	null	null
1	null	124	null	null
2	null	null	127	null
2	null	null	null	130
3	144	null	null	null

When I display this in a table in PowerBi it looks like this;

Order Number	Amount 1	Amount 2	Amount 3	Amount 4
1	138	null	null	null
1	null	124	null	null
2	null	null	127	null
2	null	null	null	130
3	144	null	null	null

However I really want to have the amount associated with each order number, i..e I want it to be displayed like this: 

Order Number	Amount 1	Amount 2	Amount 3	Amount 4
1	138	124	null	null
2	null	null	127	130

How can I do this? I want to display this data in my actual report.

[Icey]

Hi @Anonymous ,

I can't reproduce your issue. Please share us your pbix file. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

Best Regards,

Icey

[amitchandak]

@Anonymous , Check all these four column should be of number type -Amount 1 Amount 2 Amount 3 Amount 4

Ande set their default summarization as the sum

[Anonymous]

I am still running into this problem, even when summarizing each of the columns @amitchandak 

[Anonymous]

What is the setting on your Order number column?

[Anonymous]

I have it as sum currently. 

[Pragati11]

Hi @Anonymous ,

Add summarisation of SUM on all of your AMOUNT columns.

Thanks,

Pragati