如何聚合Power Bi中多个表中的列 [英] how to aggregate columns from multiple tables in power bi

问题描述

我在这里有两个表，我想总结小数3和小数4。

I have two tables here and I want to sum up measure 3 and measure 4.

这两个度量均计算一次。我想显示表格中每个国家/地区的总和，例如：德国（0.31 + 0.18 = 0.49）

both the measures are calculated once. I want to show sum against every country I have in the tables eg: Germany(0.31+0.18= 0.49)

模型数据

新结果

推荐答案

尝试一下：

NewMeasure := SumX(Filter(Country, AND(Measure4 <> Blank(), Measure3 <> BLANK()) ), MEASURE 3 + MEASURE 4)

，然后在数据视图的PowerBi上选择度量，并将格式更改为2个十进制值。

and then on PowerBi on the data view you select your measure and change the format to be with 2 decimal values.

这篇关于如何聚合Power Bi中多个表中的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！