搜索DAX公式-等同于Excel SUMIF [英] Searching for DAX formula - equivalent to Excel SUMIF

问题描述

我正在搜索DAX公式。

I am searching for a DAX formula.

具体是：

If SOLD (1st column) = count volume (second column), if not SOLD = 0 

我需要在新列中反映已售量。未售量应该为0。

I need to reflect the volume of SOLD in a new column. UNSOLD Volumes should be 0.

我附上缩小后的数据集。

I attach the reduced data set.

推荐答案

Excel SUMIF 最接近DAX SUMX 。

The Excel SUMIF is closest to the DAX SUMX.

我不是很肯定，我理解您的要求，但我想您会想要这样的东西：

I'm not positive I'm understanding what you are asking for, but I think you'd want something like this:

SOLD_VOLUME = SUMX(Table1,
                   IF(Table1[SOLD_UNSOLD] = "SOLD",
                      Table1[DAILY_VOLUME],
                      0
                   )
              )

您也可以使用过滤器执行此操作：

You could also do this with a filter:

SOLD_VOLUME = SUMX(
                  FILTER(
                      Table1,
                      Table1[SOLD_UNSOLD] = "SOLD"
                  ),
                  Table1[DAILY_VOLUME]
              )

这篇关于搜索DAX公式-等同于Excel SUMIF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！