Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am building a report about costumer complaints.
Now I am trying to get the right sum for "Reklamationskosten" (cost).
The correct answer is: 113 EUR.
The formula should do (in words):
"Sum the 'Reklamationskosten' for each 'Rekl. ID' but only once for each 'Reklamationskosten Art' "
Sure there is a way to do this in DAX but I cannot find out how.
Thank you all very much in advance!
Solved! Go to Solution.
a very nice guy on Stackoverflow gave me the solution:
Reklamationskosten Measure (Agg) =
SUMX (
SUMMARIZE (
'Table',
'Table'[Rekl. ID],
'Table'[Reklamationskosten Art],
"Reklamationskosten", MAX ( 'Table'[Reklamationskosten] )
),
[Reklamationskosten]
)
a very nice guy on Stackoverflow gave me the solution:
Reklamationskosten Measure (Agg) =
SUMX (
SUMMARIZE (
'Table',
'Table'[Rekl. ID],
'Table'[Reklamationskosten Art],
"Reklamationskosten", MAX ( 'Table'[Reklamationskosten] )
),
[Reklamationskosten]
)
Does nobody have an idea? 😢
Do I need to provide additional info?
Try a measure like , if Reklamationskosten is a column
Sumx(Values(Table[Rekl. ID]), calculate(Sum(Table[Reklamationskosten] )))
if Reklamationskosten is measure , a new measure to be used
Sumx(Values(Table[Rekl. ID]), [Reklamationskosten] )
refer if needed
@amitchandak ,
Thank you for your quick reply.
I should have noted that Reklamationskosten is a column, thank you.
So I tried as you suggested
Sumx(Values(Table[Rekl. ID]), calculate(Sum(Table[Reklamationskosten] )))
But the result then is 226 EUR.
It counts every row but should only count once per distinct 'Reklamationskosten Art' --> the result should be 113.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 68 | |
| 46 | |
| 44 | |
| 29 | |
| 20 |
| User | Count |
|---|---|
| 202 | |
| 130 | |
| 102 | |
| 71 | |
| 55 |