Calculated columns are calculated at refresh and can't have access to what is in your pivot table.
The Calculate Column would be as simple as:
Column = Table1[Value] / SUM ( Table1[Value] )
To have the result reflect only the items in the pivot table you would need to write a measure and use the ALLSELECTED function.
Code:Measure :=ResultMeasure: = DIVIDE ( SUM ( Table1[Value] ), CALCULATE ( SUM ( Table1[Value] ), ALLSELECTED ( Table1 ) ) )
Like this thread? Share it with others