Measure results not filtering/are duplicating incorrectly

[AnthonyH28]

This is probably easier for one of you to explain than for me to word!

I have a table where I combine two different sets of data into one. 

These values above exist in a table, meaning that 1ST AYD CORP shows up twice but they are identified by their Type. Type denotes the kind of sales it was, Direct or Trace.

I wrote this measure to only sum up the Trace Sales:

CALCULATE(SUM(DirectTrace[EXT Price]),DirectTrace[Type] = "T")

However, when I add that to the table, instead of it only showing up on the line there Type is T, it shows for both T and D

Primary_Customer    Type     EXT Price      Trace Sales
1ST AYD CORP           D         97,464.41      4,367.62
1ST AYD CORP           T            4,367.62      4,367.62

What I need is this:

Primary_Customer    Type     EXT Price      Trace Sales
1ST AYD CORP           D         97,464.41
1ST AYD CORP           T            4,367.62      4,367.62

I need the measure to only show up if the criteria in the measure is met. Theres thousands of customers in this table but I feel like this should be pretty easy since I have a field to identify what is what.

[AnthonyH28 · Accepted solution]

Ugh. Well I will leave the solution here for anyone else who makes this comical mistake.

Heres what I needed to do to the formula:

CALCULATE(SUM(DirectTrace[EXT Price]), FILTER(DirectTrace,DirectTrace[Type] = "T"))

Could someone smarter than me though explain why doing the Filter like this differed from the filter inside the Calculate?