使用Dax将空白值替换为零 [英] Replacing Blank values with Zero using Dax

问题描述

我想用0代替空白值，为此我在表格模型中创建了一个度量，该度量的定义为：

I want to replace blank values with zero, for this i have created a measure in tabular model, the definition of that measure is :

Test:=if (
    calculate (
        sum ( quantity ),
        flag = 1, 
        title = "WEEKS"
    ) = blank (),
    0,
    calculate ( 
        sum ( quantity ),
        flag=1, 
        title = "WEEKS" 
    )
)

虽然效果很好，但是当我将此度量拖动到某些尺寸时，它会增加行数。 / p>

Although it works fine, but when i drag this measure with some dimensions it increases the number of rows.

+-------------+-------------+------+
| Dimension A | Dimension B | Test |
+-------------+-------------+------+
| A           | C           |    0 |
| B           | X           |    0 |
| A           | X1          |    0 |
| B           | X1          |    0 |
| A           | G           |    0 |
| A           | D           |    0 |
+-------------+-------------+------+

它会增加行，例如，有一个笛卡尔坐标，当我删除if条件时，它就可以正常工作。

It increase the rows like, there is a Cartesian, and when i remove the if condition it just works fine.

+-------------+-------------+------+
| Dimension A | Dimension B | Test |
+-------------+-------------+------+
| A           | C           |    0 |
| B           | X           |  270 |
| A           | X1          |  101 |
| B           | X1          |   44 |
| A           | G           |   12 |
| A           | D           |   10 |
+-------------+-------------+------+

那么可能是什么原因，我只想将空白值替换为零。

So what could be the reason, I simply want to replace blank values with zero.

推荐答案

如果您想将blank（）值更改为零，只需在计算的末尾添加0：

If you want to change blank() values with zero, just add a 0 at the end of you calculate:

Test:=
calculate (
    sum ( quantity ),
    flag = 1, 
    title = "WEEKS"
) + 0

这篇关于使用Dax将空白值替换为零的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！