Forum Discussion
Data Model error
On this forum are people who have no contacts with support team. Just users who have different experience and who is willing to share such experience. answers.microsoft.com forum is more oriented on support.
Another option for us is on ribbon Help->Feedback-Report a problem. Such feedbacks are monitored by Microsoft, but don't expect any answer or quick fix.
And of course, paid support is always an option. With it you definitely will be answered.
Back to your issue. I have no 2016 to test, but I'd try to use explicit measures removing implicit ones. Other words, don't drag Final Rate 2 into the Values of PivotTable pane. Instead create in Power Pivot measure like
Final Rate 2, Total:=SUM( MyTable[Final Field 2] )
and use it in PivotTable. With renaming of the field on Final Rate2 measure shall pickup such change and continue to work. Implicit measure in such case will disappear. In general it's a best practice to use explicit measures only and avoid implicit measures. Again, I didn't test this with 2016, jus played with renaming.
It could be another compatibility issues with old versions, some are widely known, some not.
- SergeiBaklanJan 03, 2024Diamond Contributor
Glad it helped. 2016 is far beyond of my experience, almost forget it. However, general principals are the same. In particular nothing implicit.
- TianlinZhuJan 05, 2024Copper Contributor
Happy New Year! Thank you so much for all your help. God bless you!