Forum Discussion
Matrix is not adding up values correctly
- 6 years ago
Anonymous so you don't want each level to rolling up to the higher level, just use the value whatever it is at that level, correct?
if that is the case, just add a measure with MAX and that should do it and use this measure in your visuals
Value = MAX ( Table[Current Balance] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous so you don't want each level to rolling up to the higher level, just use the value whatever it is at that level, correct?
if that is the case, just add a measure with MAX and that should do it and use this measure in your visuals
Value = MAX ( Table[Current Balance] )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
- Anonymous6 years agoNot applicable
- Anonymous6 years agoNot applicable
I realized I have another issue because some numbers are negative. Since this measure gives me the max, it gives me zero instead of the smallest negative number for some accounts.
Do you know any way to fix this?
Thanks!