How to delete the two rows that are offset each other

[ht2567306]

Hi all,

I have a sales table and one column is called "shipment quantity", some quantities are negative and I want to delte them, but the harder part is that I also want to delete the associated positive one. 

 
For example, I surely want to delete line 3, but I also need to delete line 2. Line 2 and line 3 are exactly the same except for shipment quantity.

Thank you in advance,

[Anonymous]

HI @ht2567306 

I would rather sum them up and get 0. and filter to exclude 0.

[ht2567306]

Hi man,

How do you sum it up?

I have many rows, most of them are normal ones with shipment quantity a positive number.

How do you only sum up those 2 that are problematic.

[ht2567306]

@Anonymous 

[ht2567306]

what happened in reality is that some shipments are shipped and bounced back. hope this helps,

[Anonymous]

HI @ht2567306 

measure = Calculate(sum(table[col]), allexcept(table,table[column]))

And filter to exclude zero.

[ht2567306]

@Anonymous hey,

would you mind explaning a bit about 

measure = Calculate(sum(table[col]), allexcept(table,table[column]))

I dont think this will do the trick.

[v-deddai1-msft]

Hi @ht2567306 ,

Create a calculated column:

Column = CALCULATE(SUM('Table'[shipment quantity]),ALLEXCEPT('Table','Table'[SO NO],'Table'[date]))

Then filter your data:

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

Best Regards,

Dedmon Dai