Cityofglass88
New Member
- Joined
- May 9, 2016
- Messages
- 8
Receiving an error within PowerPivot not allowing calculations to show results for calculated columns or measures. The error is "Calculation Required" for calculated coumns.
I have the ability to choose "Calculate" from the error's menu and it will show all calculations and their results. However, if I change a formuls or filter the data in PP, it will throw the same error.
This also prevents formulas based on PivotTables from updating when filters are applied. If I go into the cell and press enter, it will calculate properly; just not update with filtering changes.
The data is pulled from a file on a shared folder via PowerQuery. I use this data connection in several other similar reports and they are working properly. Any ideas what would cause this error?
I have the ability to choose "Calculate" from the error's menu and it will show all calculations and their results. However, if I change a formuls or filter the data in PP, it will throw the same error.
This also prevents formulas based on PivotTables from updating when filters are applied. If I go into the cell and press enter, it will calculate properly; just not update with filtering changes.
The data is pulled from a file on a shared folder via PowerQuery. I use this data connection in several other similar reports and they are working properly. Any ideas what would cause this error?