Forum Discussion
Using SUM on Column A based on value in Column B?
Hello all,
As the title suggests I need to evaluate one column and then sum the value in the next. My data looks like this...
| Column A | Column B |
| Open | - |
| Open | - |
| Closed | 15 |
| Open | - |
| Closed | 2 |
| Closed | 28 |
Regards,
J
Anonymous add a measure with the following expression
Sum = CALCULATE ( SUM ( Table[Col B] ), Table[Col A] = "Closed" )Change table and column name as per your model.
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!
3 Replies
Anonymous not sure I understood, what suppose to be the expected output.
Anonymous add a measure with the following expression
Sum = CALCULATE ( SUM ( Table[Col B] ), Table[Col A] = "Closed" )Change table and column name as per your model.
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!