Looking for a DAX to filter and Sum from a table.

[Yamin101]

Hello Experts

I need to figure out the "Value" of "Actual Payment" after filtering it from the "Spreadsheet Field". 

But before all this, I need to remove duplicate "Customer ID" as I am getting a huge number of the Actual Payment.

Thanks & Regards

Yamin

[Rudy_D]

Hi,

What do you mean by 'remove duplicate Customer ID' ?

You have different value for one customer because there's different date. How do you want to filter that ?

Regards,

Rudy