Sum numbers based on unique values from column

[IT_inter]

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_problem	ID_service	inaccessibility	Service group
C-777	IT-641	234	MAIL
C-848	IT-641	45	MAIL
C-1218	IT-1015721	209	MAIL
C-1218	IT-1015720	209	MAIL
C-1501	IT-1015721	159	MAIL
C-1501	IT-1015720	159	MAIL

Thanks in advance!

[khaledHabib90]

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 🙂

[IT_inter]

Hi!

Thanks. but it didn't work.

@DimaMD worked!

[DimaMD · Accepted solution]

hi @IT_inter try it

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