Hi all

I am trying to perform a What If Anlysis on a Pivot table which is generated from a Power Pivot. I enable the What if Analyis option on the Pivot Table and when I change any values and choose perform Calculate Pivot Table with a selected Changes I get the following error
error1.JPG

I have a measure in my table which calulates the pecentage score based on Actual Score and Potential Score.
I am changing the values of the Actual Score to see what happens if it increases as I am trying to Achieve 100% scores. The actual score and Potential score are provided in my data table and the measure is created by me.

I have not done What If analysiis before on a pivot and was wondering whether I am doing something wrong.

Any help is appreciate it.

Thanks in advance