Forum Discussion
SoufTC
Helper I
Helper ISubtotals 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 cre...
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
amitchandak
Super User
Super UserSoufTC , as Score is measure
then for sum
sumx(Table, [Score])
or Sumx(values(Table[Column]), [Score]) // After Column, any group by it will sum
SoufTCHelper I
Helper Iamitchandak thank you but it only works for level 2 !
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