Avoiding calculated column in DAX

A calculated column is a DAX expression which is evaluated when the PowerPivot workbook is updated. It is very useful, but there are cases where you want to delay calculation at query time. For example:

• You want to make part of the calculation depending on the selection in the PivotTable (i.e. selecting a scenario for a simulation)
• You want to avoid the storage of another column in the PowerPivot workbook (it has a cost in terms of space, after all)

Read more...