- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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_problem | ID_service | inaccessibility | Service group |
C-777 | IT-641 | 234 | |
C-848 | IT-641 | 45 | |
C-1218 | IT-1015721 | 209 | |
C-1218 | IT-1015720 | ||
C-1501 | IT-1015721 | 159 | |
C-1501 | IT-1015720 |
Thanks in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @IT_inter try it
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @IT_inter try it
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-01-2024 12:21 PM | |||
03-14-2024 12:04 AM | |||
11-22-2023 06:11 AM | |||
03-27-2024 06:21 AM | |||
07-24-2021 09:47 PM |
User | Count |
---|---|
122 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
182 | |
119 | |
82 | |
68 | |
53 |