Calculation with Execption

[Anonymous]

Hi all,

i have a small problem with a simple calculation.

I have two relevant Columns: Counterparty and Netting Amount.

It has to be calculated in it the following way: 

Sum Netting Amount (except negative Values), but if the Counterparty is "ABC", then i want to include all values (no matter if negative or positive).

Does anybody have a solution for this small calculation?

BR

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

Does lbendlin solve your problem? As lbendlin says, I created a simple example to better understand:

SUM = CALCULATE(SUM('Table'[Netting Amount]),FILTER(ALL('Table'),[Netting Amount]>0||'Table'[Counterparty]="ABC"))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Here is the pseudo code:

Calculate (sum(netting amount),[netting amount]>0 || {CounterParty]="ABC")