Subtracting a curve

[GQinBURQUE]

Hi,

I am guessin this is a simple task, but have yet to get it working.  I have a measure, and the total of the measure is -8.08, and iI'd like to subtract that value from each row within a table.  Baiscally, I have two dynamic columns, and the difference of the averages of each needs to be subtracted form each of the values that were part of the calculated average.  I hiope the below will draw a clearer picture.  At the end, i need to be able to subtract the difference of two dyanamic averages of two different columns in two different tables, from the original individual values of one of the columns, whcih in essence will create a new column.  Essentially i need to create a curve.

name1	num 1	Num - Value = X	Name 20	num 1 b	Num - Value = X
name2	num 2	Num - Value = X	Name 21	num 2 B	Num - Value = X
name3	num 3	Num - Value = X	Name 22	num 3 B	Num - Value = X
name4	num 4	Num - Value = X	Name 23	num  4 B	Num - Value = X
name5	num 5	Num - Value = X	Name 24	num 5 B	Num - Value = X
name6	num 6	Num - Value = X	Name 25	num 6 B	Num - Value = X
name7	num 7	Num - Value = X	Name 26	num 7 B	Num - Value = X
name8	num 8	Num - Value = X	Name 27	num 8 B	Num - Value = X
name9	num 9	Num - Value = X	Name 28	num 9 B	Num - Value = X
name10	num 10	Num - Value = X	Name 29	num 10 B	Num - Value = X
name11	num 11	Num - Value = X	Name 30	num 11 B	Num - Value = X
Average	Average of Num		Average	Average of Num B
Value = Average of Num - Average of Num B

[Greg_Deckler · Accepted solution]

Soooo...the issue I see with this is that your row context is going to be enforced on your measure. In other words, your measure will be calculated within the row context. So, you will need to wrap your measure in your column calculation in a CALCULATE with an ALL or ALLEXCEPT filter most likely. Basically, you need to implicitely specify the same filter context where you get your -8.08 value.

[GQinBURQUE]

Thank You.  I was able to get it completed.   Nice work!!