Forum Discussion
Helper IGrand total not correct
Hi All
Matrix table not giving total as per data in visual, in below visual Balnce is calculated measure with some date fileter in dax.In total we need to show only 170 not 200
| MMM YY | Nov-22 | Dec-22 |
| bucket | Balance | Balance |
| Current | 170 | 187 |
| 0-30 | ||
| 31-60 | ||
| 61-90 | ||
| 91 and above | ||
| Toatal | 200 | 220 |
try using sumx instead of just sum for the balance measure
ex :
sumx(
values(tbl_name[col_name]),
calculate ( sum[tbl_name[balance])
)let me know if this works for you .
NB : the total = 193
the difference = 193 - 169 = 32
so before using sumx(), i would recommend to investigate the reason why the total is adding 32 . ( unless you know the reason and you want to exlude the 32 , and have the total = base on the numbers that are displayed in the visual )
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
2 Replies
- Daniel29195
Community Champion
try using sumx instead of just sum for the balance measure
ex :
sumx(
values(tbl_name[col_name]),
calculate ( sum[tbl_name[balance])
)let me know if this works for you .
NB : the total = 193
the difference = 193 - 169 = 32
so before using sumx(), i would recommend to investigate the reason why the total is adding 32 . ( unless you know the reason and you want to exlude the 32 , and have the total = base on the numbers that are displayed in the visual )
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠 You can try the following measure.
Measure = SUMX ( VALUES ( Table[bucket] ), [Balance] )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
