Summarize value lines duplicated

[FJME]

Hi guys !

I'm managing a long retail provisioning list to merge in a next step with a sales table and after trying to eliminate lines due to file lenght i'm not able to merge quantity duplicate lines by shop (destination store). I tried pivot table but i need to maintain many lines ...consolidate is not an option (only values)...subtototals.... etc. I append the file (just one monthly list...) to ilustrate (initial lines highlighted).

Regards

Francisco

[amitchandak]

@FJME , You can have a measure like

sumx( summarize(Table, Table[DestinationID], Table[CategoryId], "_qty", sum(Table[Quantity]) ), [_qty])