Forum Discussion
Grand total not correct
- 2 years ago
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.