Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm trying to produce a calculated column "delay penalty" that is calculated based on some user input parameters.
These work on their own in simple calculations but with a larger fuction the calculation is always done with the default value. Any change in the selected values produce a different output. The calculation is correct with the default values, so the function is otherwise correct.
Function below, I have tried replacing the parameters with every option, even with the SELECTEDVALUE function. Selection never affects the result.
Parameters in bold.
Solved! Go to Solution.
Hi @Anonymous ,
Power bi not support to create dynamic calculated column based on slicer/filter. Please use measure to instead, it can be dynamic changes based on filter selection.
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
Power bi not support to create dynamic calculated column based on slicer/filter. Please use measure to instead, it can be dynamic changes based on filter selection.
Regards,
Xiaoxin Sheng
Hi, @v-shex-msft
Thank you for the response, this explains it. Could you provide any assistance on how to do the calculation if I simplify it like this:
I need a value for each 'purchase order' row:
'Total oder value (column)' * 'Delay'(calculated from a column depending on a variable parameter) * Percentage (parameter)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |