Forum Discussion
Numeric range parameter not being read correctly when trying to create a new column
Hi I am trying to use a numeric range parameter to create a new column. I've been pulling my hair out because it looks like PowerBI is just reading the parameters as blank. See below the first ...
Hi Anonymous ,
Here's why you're seeing blank:
- While you can use a measure in a calculated column or table, the result does not respond to the slicer selection. It updates only upon data refresh or when the referenced column or the formula itself is modified.
- SELECTEDVALUE function that is used in the generated parameter measure returns blank if there are more than one values. There are more than one values because, as stated in the reason above, your measure does not respond to the slicer selection. Each row your calculated column reads your measure as BLANK.
Hi mate
I've tried refreshing the data and using SELECTEDVALUE multiple times but am still having the same issue.
What do you mean when you say there are multiple values? Each parameter only has one value.