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

[Sam_Sun_2018]

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 ?

[v-hashadapu]

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.

[v-hashadapu]

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.

[v-hashadapu]

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.

[v-hashadapu · Accepted solution]

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.

[FBergamaschi]

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