Forum Discussion

QQQ's avatar
QQQ
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Use DISTINCT as filter when calculating SUM

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, th...
Need Help
  • marcorusso's avatar
    marcorusso
    9 years ago

    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]
)
marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

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's avatar
    QQQ
    Icon for Advocate II rankAdvocate II
    9 years ago

    marcorusso Thanks for the quick response!