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