Forum Discussion
Using parameter numeric range in a calculated colunn in PowerBi desktop
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
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.