Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |