Parameters selection doesn't work, only produces output with default value

[Anonymous]

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.

Delay penalty =

IF('Delay penalty per week or day'[Delay penalty per week or day Value] = 0;

IF('PO data'[Delay in weeks] > (([Max penalty weeks Value]) *-1);

('PO data'[Delay in weeks] * 'PO data'[Total Order Value] * [Penalty % per day/week Value]) *-1;

([Max penalty weeks Value]) *-1 * 'PO data'[Total Order Value] * [Penalty % per day/week Value]) ; 1)

[Anonymous · Accepted 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

[Anonymous]

Hi, @Anonymous 

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)