All Calculated tables are refreshed when the measure is updated in PBIX file

[sunyangjun1115]

Hello Community,

i have a PBIX file which contains some calculated tables and measures. i noticed that when i make the changes to the measure, it will take some time to save the changes. i observed that the reason why it takes time to save the changes to the measure is that all Calculate tables are refreshed.

the calculated tables do not use the measure that i made changes to . does anyknow know what is the reason why this is happening and how to resolve this ?

[v-nmadadi-msft · Accepted solution]

Hi @sunyangjun1115 
Thanks for reaching out to the Microsoft fabric community forum.

When you create a calculated column or a calculated table In Power BI Desktop, their contents can be viewed immediately in the Data view. They are also recalculated every time you refresh data.

While it may seem counter-intuitive, calculated columns and calculated tables are also recalculated every time you create or edit measures in Power BI Desktop. This is why sometimes in large models editing a measure takes a long time, accompanied by the Working on it message

While you can't disable this refresh entirely (it's by design), there are some strategies to reduce its impact:
1) Use measures instead of calculated tables where possible. Measures are evaluated on demand, while calculated tables lock in data at refresh time so using measures can eliminate unnecessary overhead.
2) Off-load heavy table logic to Power Query or use aggregation tables. Processing in Power Query runs during data refresh not when measures change and is generally more performant.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[sunyangjun1115]

thanks for your support, @v-nmadadi-msft . very helpful. 

[HarishKM]

@sunyangjun1115 Hey, 

Kindly follow below method.

Reasons:

Power BI recalculates to ensure all interdependencies are maintained for data integrity and optimal performance.

Calculated tables might be indirectly connected to other elements or filter contexts that involve the changed measure.

Power BI often processes the entire model to ensure performance optimization and accurate results.

Potential Solutions:

Analyze the relationships and dependencies within the model to identify any unnecessary links or complex logic.

Setting up incremental refresh policies can minimize the need for full refreshes, improving performance.

 If possible, simplify or recreate calculated tables using simple DAX expressions to avoid extensive recalculation.

 Microsoft documentation or the community forums may offer updates or solutions tailored to specific deployments.

Thanks

Harish M

Please accepts this as a solution if it is solve your problem and give kudos as wel