Forum Discussion

IT_inter's avatar
IT_inter
Frequent Visitor
2 years ago
Solved

Sum numbers based on unique values from column

Hi guys!

 

I have simple question creating a measure which SUM number based on unique values from column. Unfortanately i didn't find any references, maybe my search query isn't correct.

I have following table and i want to SUM inaccessibility based on unique key_problem.
Based on table below i expect to get SUM = 234 + 45 + 209 + 159 = 647.

 

key_problemID_serviceinaccessibilityService group
C-777IT-641234MAIL
C-848IT-64145MAIL
C-1218IT-1015721 209MAIL
C-1218IT-1015720209MAIL
C-1501IT-1015721159MAIL
C-1501IT-1015720159MAIL

 

Thanks in advance!

Need Help
  • DimaMD's avatar
    DimaMD
    2 years ago

    hi IT_inter try it

    Measure = SUMX( SUMMARIZE('table3',table3[key_problem],table3[Service group],table3[inaccessibility]),[inaccessibility] )

3 Replies

  • DimaMD's avatar
    DimaMD
    Solution Sage
    2 years ago

    hi IT_inter try it

    Measure = SUMX( SUMMARIZE('table3',table3[key_problem],table3[Service group],table3[inaccessibility]),[inaccessibility] )
  • khaledHabib90's avatar
    khaledHabib90
    Resolver II
    2 years ago

    Hello,

    please try this measure

    = SUMX(VALUES(Key_ProblemID),max(inaccessibility))

    this measure should work correctly if the values are the same for each duplicated problem ID

     

    If my reply solved your problem, please mark it as the solution 🙂