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 -...
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!
Hey,
Sorry I probably should have explained better...
Look for all values that are "closed" in A then SUM "B"
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!