Sum value by column filter

Question

Basically want to do a sum based upon a filter. I created a column where 1 represents PO# formats I want to filter by

=Sum(Exp[Release_Note_Qty],Exp[Pipe_POS_1]=1) but it is not working

I am trying to determine what I am doing wrong here, any ideas?

Thanks for your help

Kevin

Answer 1

Try using the below:

=Calculate(Sum(Exp[Release_Note_Qty]),Exp[Pipe_POS_1]=1)

By embedding the code in calculate function you will be able to get the desired result. 

---

Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

Answer 2

Worked Thank you