Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix is not adding up values correctly

So I have a parent-child hierarchy represented as a matrix. It works fine when it is fully expanded (i.e. the right account id corresponds to the right account balance) as seen below. And the current...
  • parry2k's avatar
    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.