Forum Discussion

ht2567306's avatar
ht2567306
Icon for Helper I rankHelper I
6 years ago

How to delete the two rows that are offset each other

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 ...
ht2567306's avatar
ht2567306
Icon for Helper I rankHelper I
6 years ago

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's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

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