Is there a way to populate a column with scalar value in power pivot?

0
votes

I'm new to Power Pivot, sorry if the question is simple but i've been searching for hours already and i can't find an answer to this. The table below is from Power Pivot's Manage. The total Sum of (CoveredAndGapTotal) is 147. The table below is filtered therefore my CoveredAndGapTotal's sum (SumCandG) is 22. Is there a way to convert SumCandG to column? Because when i put the same formula (SUM([CoveredAndGapTotal]) in the column (Calculated Column 1), the return value is 147 and not 22. It sums up all the data regardless of the filter.

enter image description here

1
powerpivot

1 Answers

2
votes

This is not possible, a calculated column is not related to filtering. That's why it's needs to be a calculated measure. When you are using this in an Excel pivot table, you will see that you can use these to calculate.

What result are you expecting in the pivot table in Excel?