PowerBI区分BLANK值和0值 [英] PowerBI Differentiate BLANK value and 0 value

问题描述

有没有办法区分列中的空白值和列中的 0 值，当我使用 if 语句进行测试时，它们被视为相同的值...有什么建议吗?

Is there a way to differentiate between a blank value in a column and a 0 value in a column, when I tested with an if statement they were treated as the same value... any suggestions?

推荐答案

是的，有.在计算列中，首先测试一个值是否为空白，然后测试是否为零:

Yes, there is. In a calculated column, first test a value for being blank, then test for beign zero:

因此，创建一个标志并通过它过滤您的总和度量，即，

So, create a flag and filter your sum measure by it, i.e,

No blanks sum = CALCULATE( SUM(Table[Amount]), Test <> "Blank")

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