Sum Multiple Filtered Sums

[spencer_g]

Hello Everyone, 

I have two columns of data (Arrivals and Departures) and I have a summed measure (Total Operations), all in one table. I then have a seperate table (Info) that contains Dest_Terminal and Orig_Terminal. I need to Filter the Total Operations by terminal, and I have tried doing so in the Visual Filters area of the chart, but it isn't working. 

So, I wanted to create a new measure that filters out all of Terminal A's arrivals and departures, and here is the forumla I came up with (that obviously isn't working):

Total Ops Terminal A = calculate(sum(Flights[Arrivals]), filter(Info, Info[Dest_Terminal] = "A") + sum(Flights[Departures]), filter(Info, Info[Orig_Terminal] = "A"))

Can someone please tell me how to make this work?

Thanks in advance!

[Anonymous · Accepted solution]

Total Ops Terminal A = calculate(sum(Flights[Arrivals]), filter(Info, Info[Dest_Terminal] = "A")
                                  + calculate(sum(Flights[Departures]), filter(Info, Info[Orig_Terminal] = "A")

[spencer_g]

Thanks! Worked like a charm!