PowerBi Matrix - 将小计显示为平均值，忽略空白单元格
我有一个使用 DIVIDE 函数的度量，它结合了基于不同表中的列的其他两个度量。 矩阵自动显示行小计的平均值。 但是，我不清楚在计算平均值时如何防止它在空白单元格中计数。
我无法在网上找到解决方案，即使这看起来是一个简单的问题。
% of Full Time = CALCULATE (DIVIDE([Actual Hours Heatmap], [Heatmap Capacity]))
Measure from source 1:
Heatmap Capacity = ROUND (calculate( sum('Workday Target per CC'[Hour Target]) * sum('Employee Mapping'[eMPLOYEE Count])), 2)
Measure from source 2:
Actual Hours Heatmap = ROUND (sum(Actuals Input[Hours ACT]),2)
- AVERAGEX 函数
- FILTER 函数
- 舍入
- 过滤器 - 度量值不为 0 且不为空
I have a measure using DIVIDE function, that combines two other measures based on columns from different tables.
The matrix shows averages in row subtotals automatically.
However, it is not clear to me how to prevent it from counting in blank cells when calculating averages.
I can't find solution anywhere online, even though it seems like a simple problem.
% of Full Time = CALCULATE (DIVIDE([Actual Hours Heatmap], [Heatmap Capacity]))
Measure from source 1:
Heatmap Capacity = ROUND (calculate( sum('Workday Target per CC'[Hour Target]) * sum('Employee Mapping'[eMPLOYEE Count])), 2)
Measure from source 2:
Actual Hours Heatmap = ROUND (sum(Actuals Input[Hours ACT]),2)
- AVERAGEX function
- FILTER function
- Rounding
- Filter - measure is not 0 and not blank
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
为每个单元格重新计算测量值。总数不是平均值的平均值；而是平均值。这是在面积上没有任何活动过滤器的情况下计算的度量。
Measures are recalculated for each cell. The total isn't an average-of-averages; it's the measure calculated without any active filter on Area.