- 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

Subtotals in Matrix with Hierarchy not adding up
Hello everyone,
I'm struggling to solve this problem !
So, I have this hierarchy in matrix with 2 level between two table linked with column "City"
level 1 : "RESP CONTENT"
level2 : "City"
I created the matrix as below as below using as hierarchy the columns of "table 1" : "RESP CONTENT" and "City"
With :
Please, any help?
Thank's in advance
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HI @SoufTC,
I think you need to add if statements to check all hierarchy levels and write corresponding expressions for each level aggregation.
Clever Hierarchy Handling in DAX - SQLBI
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@SoufTC , as Score is measure
then for sum
sumx(Table, [Score])
or Sumx(values(Table[Column]), [Score]) // After Column, any group by it will sum
- 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 @SoufTC,
I think you need to add if statements to check all hierarchy levels and write corresponding expressions for each level aggregation.
Clever Hierarchy Handling in DAX - SQLBI
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-01-2024 01:12 AM | |||
Anonymous
| 04-25-2025 12:29 AM | ||
05-16-2025 01:32 AM | |||
Anonymous
| 05-13-2022 12:54 AM | ||
Anonymous
| 05-29-2018 11:34 AM |
User | Count |
---|---|
73 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
37 |