将 PowerBI 中的(空白)值替换为零 [英] Replace (Blank) values in PowerBI with Zero
问题描述
我正在尝试在 PowerBI 中设置住院治疗仪表板,并使用 KPI 指标来展示该特定位置的患者数量.
I'm trying to set up a Hospitalization Dashboard within PowerBI and I'm using the KPI indicator to showcase the number of patients in that particular location.
我的源数据如下所示:
Full Name | ID | Location
Patient A | xxxxxA | ITU
Patient B | xxxxxA | IDU
然后我生成一个 KPI 指标,如果是位置计数,并针对包含ITU"的任何内容进行过滤.有时,这会在指标中生成一个(空白)"值,我想知道如何用零替换它.不知何故无法弄清楚从哪里开始,是否要进行测量等.
Then I generate a KPI indicator that if is Count of Location and filtered for anything that contains 'ITU'. At times, this generates a '(BLANK)' value in the indicator and I would like to know how to replace this with zero. Somehow can't figure out where to get started, if to do a measure etc.
以下问题不知何故没有帮助:
The following questions somehow didn't help:
任何帮助将不胜感激!
推荐答案
如果您的 KPI 度量是数字,那么您通常只需将 + 0
添加到度量中,因为
If your KPI measure is numeric, then you can usually just add + 0
to the measure since
BLANK() + 0 = 0
这篇关于将 PowerBI 中的(空白)值替换为零的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!