有没有一种方法可以在幂支点中用标量值填充列？ [英] Is there a way to populate a column with scalar value in power pivot?

问题描述

我是Power Pivot的新手，很抱歉，如果问题很简单，但是我已经搜索了几个小时，却找不到答案。下表来自Power Pivot的管理。 （CoveredAndGapTotal）的总和为147。下表已过滤，因此我CoveredAndGapTotal的总和（SumCandG）为22。是否可以将SumCandG转换为列？因为当我将相同的公式（SUM（[CoveredAndGapTotal]）放在列（计算列1）中时，返回值为147而不是22。它汇总所有数据，而不考虑过滤器。

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.

推荐答案

这是不可能的，计算列与过滤无关，这就是为什么它需要作为计算量度的原因
在Excel数据透视表中使用此列时，您会看到可以使用这些列进行计算。

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.

您希望在Excel的数据透视表中得到什么结果？

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

这篇关于有没有一种方法可以在幂支点中用标量值填充列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！