如何聚合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.