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 fo...
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] )
khaledHabib90's avatar
khaledHabib90
Icon for Resolver II rankResolver 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 🙂

IT_inter's avatar
IT_inter
Frequent Visitor
2 years ago

Hi!

Thanks. but it didn't work.

 

DimaMD worked!