Calculated columns not refreshing?

[Anonymous]

Hello,

I have refreshed my Power BI report (Query + Desktop). The Power BI desktop table is now correctly reflecting my new source data. However, the calculated colums in my table are not refreshing? The data related to my old source data is still shown, even upon forcing another refresh on the table.

Example:

Original PBI Desktop Data:

Purch ID	Calculated column 1
1	Result A
2	Result B
3	Result C

Data after refresh is showing new Purch IDs but the results to the calculated column are wrong as they are still showing the exact results from that row from the original data. So the calculated column formula is not refreshing. How is that possible and how can I make sure these calculations are refreshing? I have never run into this issue before.

Purch ID	Calculated column 1
4	Result A
5	Result B
6	Result C

This is the formula for Calculated column 1:

sumx(relatedtable(VendPackingSlipTrans),'VendPackingSlipTrans'[QTY])

Thank you!

[Anonymous]

Hi @Anonymous ,

Hard to reproduce the scenario. Can you show some sample data to us?

Best Regards,

Jay

[lbendlin]

did you refresh all the data sources in your Power BI Desktop file, or just a single one? Specifically, did you refresh VendPackingSlipTrans  AND the table that hosts your calculated column?

[Anonymous]

Dear @lbendlin , All tables have been refreshed. I did it a second time as well after closing and re-opening the file to see if that would solve the problem but it didn't.