How to filter out a column value and only perform addition and subtraction as per that column value?

[Anmolgan]

I am using the below dax to filter out a value as per a column value and narrow down all the calculations:

OEMSALES= Calculate([GMMargin], Filter('TableA', [Column1]= "Sales"))

GMMargin is my measure here, so as per the above DAX this will filter out only the values that have "Sales" in Column1 right, and whenever I use this measure as a number chart it changes only as per Sales column and turns out to be blank for all other values that make sense, but when I define the above in a variable and perform some addition subtraction, it just does not falls out to be in correct place, do anyone has any idea how can i define the variable in above so that I can only see the calculations of Sales values in column1??

[Greg_Deckler]

Seems like there is missing information here, I can't be sure of what you are asking. If you are asking that if you take what you have provided in the formula and do some extra addition and subtraction that you get data in places other than sales, then you could create a separate measure that does something like:

Measure = IF(ISBLANK([GMMargin]),BLANK(),<DO YOUR CALCULATION HERE>)

So basically, if that measure you have is blank, return blank, otherwise do you additional addition and subtraction calculation.

[Anmolgan]

I want to filter out a column according to a value stored in those columns, and after filtering I need to add up all those values that comes after filtering out a column.