Forum Discussion
Need help with making calculated field dynamic.
Resident RockstarCalculated columns will only update when you refresh your entire dataset. The fields won't dynamically update with whatever filters you're currently applying.
To get a result that dynamically updates, you need to create it as a measure instead of a calculated field.
Thank you so much for your reply. I had considered using a measure instead of a column but the issue am running into creating a measure is that because there are duplicate string in the "Line Item Description", i.e. 'Pre-Tax Book Income (Loss)', I run into the error below.
Am I missing something? How should I approach the formula?
Bumping up this thread in hope of someone has a solution to this issue.
- Cmcmahan
There are a few ways to handle the error you're seeing.
The easiest is to use an aggregation. If the context you plan to need the result in is only ever one item, you can use SELECTEDVALUE([Line Item Description]) in order to aggregate.
The underlying problem is not because of having duplicates in your category column, but the measure not knowing which [Line Item Description] you mean. When you're creating a calculated column, the context is inferred to be "current row". You can read more about it here.