Forum Discussion
Using parameter numeric range in a calculated colunn in PowerBi desktop
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
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.
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 Tutorials - SPGuides
When to use Calculated Columns and Calculated Fields - Microsoft SupportBest Regards,
Yang
Community Support TeamIf 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
2 Replies
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.
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 Tutorials - SPGuides
When to use Calculated Columns and Calculated Fields - Microsoft SupportBest Regards,
Yang
Community Support TeamIf 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