Forum Discussion
Parameter for Measure
Hi All,
just wanted to check how can i use the parameter for column calculation?
I have multiple DAX columns created and I want to change the numbers by giving a Parameter.
I need to give parameter after > should get selected automatically. I cannot create a measure for this because it should be added at each row level.
Hi RanjanThammaiah ,
I think the what-if-parameter is the workaround you want.
You can create what-if variables for your reports, interact with the variable as a slicer, and visualize and quantify different key values in your reports.
Reference: Create and use what-if parameters to visualize variables in Power BI Desktop
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Calculated columns cannot be responsive to dynamic parameters in a report since they are only calculated once each time the table they belong to is refreshed.
Hi RanjanThammaiah ,
I think the what-if-parameter is the workaround you want.
You can create what-if variables for your reports, interact with the variable as a slicer, and visualize and quantify different key values in your reports.
Reference: Create and use what-if parameters to visualize variables in Power BI Desktop
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi RanjanThammaiah ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
