Forum Discussion
Sumx total in each row
Hello all, In the following image you see for the customer 301000133 for each invoice number the outstandin amount. The outstanding amount is calculated by invoiceamount - paid. The curr...
=CALCULATE (
[Outstanding amount],
ALLEXCEPT ( Table[Customer] )
)
=CALCULATE (
[Outstanding amount],
ALLEXCEPT ( Table[Customer] )
)