topic Re: All Calculated tables are refreshed when the measure is updated in PBIX file in DAX Commands and Tips

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

Sam_Sun_2018 — Wed, 16 Jul 2025 02:33:35 GMT

Hello All,

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 ?

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

FBergamaschi — Wed, 16 Jul 2025 06:58:43 GMT

Power BI recalculates to ensure the integrity of the data model in its entirety

The formula of a calculated table might contain calculated columns, other calculated tables, or measures references

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

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

v-hashadapu — Wed, 16 Jul 2025 08:45:56 GMT

Hi Sam_Sun_2018 , Thank you for reaching out to the Microsoft Community Forum.

In Power BI, when you modify a measure, all calculated tables in the model will be re-evaluated, even if they don’t reference that measure. This happens because calculated tables are part of the model’s semantic layer and are always recalculated when the model changes. Power BI uses a conservative dependency strategy and doesn't limit recalculations to only directly affected objects.

This behaviour is by design and hasn’t changed in recent updates. To avoid unnecessary recalculations, move logic from calculated tables to Power Query when possible, since Power Query tables only refresh during data load, not on model edits.

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

v-hashadapu — Mon, 21 Jul 2025 11:51:46 GMT

Hi Sam_Sun_2018 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

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

v-hashadapu — Thu, 24 Jul 2025 10:55:39 GMT

Hi Sam_Sun_2018 , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

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

v-hashadapu — Mon, 28 Jul 2025 06:58:21 GMT

Hi Sam_Sun_2018 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.