Forum Discussion
Field parameter in custom column
Calculated columns are unable to recognize user filters such as the selected value of a field parameter. Also, would you clarify the logic of comparing a single value in column XYZ to the selected value of a field parameter (this would be a column name or measure name)?
The XYZ column assigns to the X, Y or Z group, no other value occurs there and therefore I want it to be compared within the correct parameter. What I want to achieve is for the user to determine what is an acceptable boundary for a given X, Y or Z category. I hope this makes it a little bit clearer. Is there any option how the user can choose the parameter to use in the DAX code for the column?
It sounds as if you want a numeric range parameter which allows you to set a boundary and perform calculations/filtering based on that boundary. The same constraint applies to using a numeric range parameter in a calculated column; you would need to use a measure. Here's an article on the topic:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
I already tried this too and unfortunately it didn't work, I use this parameter for conditional formatting where it works normally, so I really don't know where the problem is why it works in other DAX code and not here.