Forum Discussion
Subtracting a curve
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 |
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.
2 Replies
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.
Thank You. I was able to get it completed. Nice work!!
