Forum Discussion
Need help with making calculated field dynamic.
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.
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.
