Use DISTINCT as filter when calculating SUM

[QQQ]

Here is a table

Incident_ID	Triggers	Status
7545714	41	Red
7545714	41	Green
7545883	16	Purple
7549800	15	Red
7549800	15	Green
7549800	15	Orange

Given, there will alway be same number of triggers for a particular ID. But I don't want to count those triggers multiple times.

I tried the following DAX. My expected answer is 72, but I get 143 instead. How to fix?

Distinct_Matches:=CALCULATE(sum(Incidents[Triggers]),DISTINCT(Incidents[Incident_ID]))

[marcorusso · Accepted solution]

If you are sure that Triggers and Incident_ID have a 1:1 relatioship, you could use this:

Distinct_Matches :=
SUMX (
    SUMMARIZE ( Incidents, Incidents[Incident_ID], Incidents[Triggers] ),
    Incidents[Triggers]
)

[QQQ]

@marcorusso Thanks for the quick response!