Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
IT_inter
Frequent Visitor

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.

IT_inter_0-1697724496656.png

 

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!

1 ACCEPTED SOLUTION
DimaMD
Solution Sage
Solution Sage

hi @IT_inter try it

DimaMD_0-1697725508765.png

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

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

View solution in original post

3 REPLIES 3
khaledHabib90
Resolver II
Resolver II

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 🙂

Hi!

Thanks. but it didn't work.

 

@DimaMD worked!

DimaMD
Solution Sage
Solution Sage

hi @IT_inter try it

DimaMD_0-1697725508765.png

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

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.