Forum Discussion
Using measures in calculated columns
I want to create a calculated column (which I want to use for further calculations) which holds the value of the above measure but instead it recalculates the expression for each row
Calculated Columns are evaluated and calculated before the user even starts tinkering with Filters, Slicers, or anything like that. So, the misunderstanding is that Query and Filter Context do not apply to Calculated Columns on rows. Thus, if you add a measure value to a calculated column, it will only abide by the Row Context and the calculated column value of a measure will be the same for every row in your table.
You will need to shift your thinking a little, create a new Measure based on your already existing Measure in order to utilize filter and query contexts. Read the article a bunch, my brain hurt for a long time before DAX even started to make sense even a little bit.
Here is a snippet from MSDN:
For example, suppose you create this simple formula that sums the values in the Profit column of the Sales table: =SUM('Sales'[Profit]). If you use this formula in a calculated column within the Sales table, the results for the formula will be the same for the entire table, because the query context for the formula is always the entire data set of the Sales table. Your results will have profit for all regions, all products, all years, and so on.