Parameter for Measure

[RanjanThammaiah]

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.

Available week 1 = IF('EMEIA FSO CNS - Available Hours'[Available Time Week 1]> 16,"1","0")

Kindly let me know if I can do any workaround for this.

Regards,

ranjan

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[AlexisOlson]

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.