Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Variable factor in a calculated column

Hi all,   I could use some help with the following..   This is my model:       The data looks like:    The table 'Factor' goes from 0,00 to 2,00 in increments of 0,01.   Now, ...
Need Help
Wimverh's avatar
Wimverh
Icon for Resolver IV rankResolver IV
6 years ago

It is impossible to use a column calculated by design for this requirement.

A computed column is calculated during table load and then stored in the model. Therefore, you cannot change based on a report parameter.

You have to redesign your other measurements, to work with a measure instead.

Explanation of the differences between calculated columns and measures:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/