- 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.

User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |