Sum with IF condition and distinct IDs

[pgloc2020]

Hello all,

I am trying to generate 2 KPIs to display total Debit and Credit amounts separately.

In my dataset I have a values like below. ID column has some duplicate ID's -

I have tried many expression including below expressions but none of it giving me the correct total -

Sum({<Financial Transaction Type = 'DA Credit'>} Aggr(Sum(DISTINCT {<Financial Transaction Type = 'DA Debit'>} AMOUNT), ID)) or

Sum(aggr(sum(DISTINCT if(Financial Transaction Type = 'DA Credit', ID)), AMOUNT)) or 

SUM(distinct if ([Financial Transaction Type]='DA Debit', [AMOUNT])) - This one is working but it is not eliminating the duplicate IDs amount. 

Kindly help me to get it as it is required for my project.

Thanks in advance.

[Lisa_P]

Try this:

Sum({<[Financial Transaction Type] = {'DA Credit'}>} DISTINCT  AMOUNT)

and 

Sum({<[Financial Transaction Type] = {'DA Debit'}>} DISTINCT  AMOUNT)