Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
hi @IT_inter try it
Measure = SUMX( SUMMARIZE('table3',table3[key_problem],table3[Service group],table3[inaccessibility]),[inaccessibility] )
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 @IT_inter try it
Measure = SUMX( SUMMARIZE('table3',table3[key_problem],table3[Service group],table3[inaccessibility]),[inaccessibility] )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
75 | |
54 | |
38 | |
31 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |