Forum Discussion
Variable parameter in DAX formula
Hello everyone, I have an issue that I am struggling with and I hope that you can help me with my issue. In Power BI I want to calculate whether there is a certain exceedance or not. For that I...
Hi Dale,
thank you for your response. I have confirmed that your solution works when I want to define a a measure this way. Somehow it doesn't seem to work for calculated columns which is what is necessary to implement the full solution.
Is there a similar approach by using dynamic parameters which can be used for calculated columns?
If so, how?
I look forward to hearing from you.
Kind regards,
Jasper
Hi Jasper,
The calculated columns can't respond to the slicer. So we can't do it like the measure. There could be a workaround. Please refer to the snapshot. We can add a new column in the Query Editor with parameters. Finally, you can change the parameter. But it can't as dynamic as a slicer.
Best Regards,
Dale