Created a summarized table, but my rows didn't aggregate for some reason.

[Anonymous]

I included pictures of the DAX used and the export showing there are multiple rows of the same "concat shipment table"

I wanted to create this table to connect it as the "One" side to a "Many" table, but I have duplicate "concat shipment table" rows.

Any idea how to aggregate these rows? I thought Summarized would od it 

[v-rongtiep-msft]

Hi @Anonymous ,

Could you please provide  your pbix file qithout privacy inormation for us to test? I cannot reproduce the issue.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HoangHugo · Accepted solution]

Hi

For numberic columns (Gross ship USD, net Qty), you use SUM to SUMARRIZE to avoid duplicate. Try this one

Table= SUMMARRIZE(FILTER(...),
[Concat shipment table],
SUM([Gross Sales USD],
SUM([Net Qty],
SUM([Gross Ship USD],
[List price])