DAX 条件和 [英] DAX conditional sum

问题描述

如何构造一个返回 A 或 B 之和的 DAX 度量.如果 A 为空，则逻辑是取 B.所以预期的结果是这样的:

How to construct a DAX measure which returns sum of either A or B. The logic is take B if A is empty. So expected results looks like this:

+---+---+----------+
| A | B | Expected |
+---+---+----------+
| 1 |   |        1 |
| 1 |   |        1 |
|   | 2 |        2 |
| 1 | 2 |        1 |
|   | 2 |        2 |
+---+---+----------+
| 3 | 6 |        7 |
+---+---+----------+

当我使用度量时:

Measure = IF(ISBLANK([SUM(tab[A])]), SUM(tab[B]), SUM(tab[A]))

我总共得到 3 个，这是合乎逻辑的，但不是我所期望的.

I get 3 for total which is logical but not what I expect.

推荐答案

我建议在这种情况下使用 SUMX 迭代器.

I'd recommend using a SUMX iterator in this case.

Measure = SUMX ( tab, IF ( ISBLANK ( tab[A] ), tab[B], tab[A] ) )

您也可以执行以下操作:

You might be able to do the following as well:

Measure = 
    CALCULATE ( SUM ( tab[A] ) ) +
    CALCULATE ( SUM ( tab[B] ),
        FILTER ( tab, ISBLANK( tab[A] ) )
    ) 

这篇关于DAX 条件和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！