Forum Discussion
Parameters
Hi
I created the following parameter, attached to a slicer to be able to modify its value. As follows:
Then I created a custom column, where I would like that each line value is automatically set to that parameter value. I did as follows. But as you can see it does not work. Do you know how to proceed?
Hi Anonymous ,
What if parameter can only be used in measure instead of calculated column, so you can create measure like DAX below.
Meaure1= Parameter[Parameter Value]
You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Anonymous You cannot have a calculated column interact with a slicer since columns are only calculated at data load/refresh.
Anonymous , Calculated column can not take dynamic value from the slicer. So think how can you get the same as a measure .
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Hi Anonymous ,
What if parameter can only be used in measure instead of calculated column, so you can create measure like DAX below.
Meaure1= Parameter[Parameter Value]
You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
