Sum of distinct values by customer and Status

[bml123]

I have data like shown below. I want the sum of distinct values by id and status.

Id	Status	Amount
1	A	100
1	A	200
1	A	100
1	B	400
1	B	400
1	B	300

I have a filter in my report with status drop down containing A, B etc. 

When status A is chosen it should show the output as below

Id	Status	Total
1	A	300

when status B is chosen it should show the output as below

1

B

700

[Fowmy]

@bml123 

Create the following measure:

Dis. Total = 
SUMX(
    DISTINCT(Table[Amount]),
    Table[Amount]
)

[bml123]

@Fowmy

Hi, thank you. How can we sum the values by id including all the values, not just distinct values?

[Fowmy]

@bml123 

Not clear, can you show me the expected result based on your sample?

[bml123]

Sorry for not being clear.

Expected output for status A should be 400

Expected outout for status B should be 1100

it just need to add all the amounts irrespective if they are same or not.

[Fowmy · Accepted solution]

@bml123 

A simple SUM would do:

Total = SUM( Table[Amount])