Using parameter numeric range in a calculated colunn in PowerBi desktop

[RKAD]

I would like to calculate a value of percentage in Test DPR according to values in two other colunns PARI and Rapport juste like this :  

Then I would the condition of each switch case (Rapport 1, Rapport 2 and Rapport 3) and action to do for each case (GAG, JUG...etc ) to be dynamic and adjustable by the user througth  some parameter numerci range 

The Rapport 1 Rapport 2 and Rapport 3 paramter numeric range work properly  but the GAG1 JUG1 dont at all I tried différence mays to insert then in the formula but nothing works

The colunn results just blank

Could you please help me to solve this issue ?

Thank you very much for your help 

[johnt75 · Accepted solution]

Calculated columns are only calculated during data load or refresh, they are not affected by any slicers or filters. If you want something to react dynamically then you must use a measure.

[Anonymous · Accepted solution]

Hi, @RKAD 

Thanks for @johnt75's reply. Here's some additional content. Calculated column store the data in the model once it is written and are not affected by filters such as slicers; Measure changes in real time and is affected by filters, so you should try to use measure rather than calculated column.

Difference Between Calculated Column and Measure in Power BI - SharePoint & Microsoft Power Platform...
When to use Calculated Columns and Calculated Fields - Microsoft Support

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[johnt75 · Accepted solution]

Calculated columns are only calculated during data load or refresh, they are not affected by any slicers or filters. If you want something to react dynamically then you must use a measure.