Reply
IT_inter
Frequent Visitor
Partially syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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 🙂

Syndicated - Outbound

Hi!

Thanks. but it didn't work.

 

@DimaMD worked!

DimaMD
Solution Sage
Solution Sage

Syndicated - Outbound

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
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)