用零替换 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"的任何内容.有时,这会在指标中生成一个(BLANK)"值,我想知道如何将其替换为零.不知何故不知道从哪里开始,是否要进行测量等.
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.
以下问题无济于事:
任何帮助将不胜感激!
推荐答案
如果您的 KPI 度量是数字,那么您通常只需将 + 0
添加到度量中,因为
If your KPI measure is numeric, then you can usually just add + 0
to the measure since
BLANK() + 0 = 0
这篇关于用零替换 PowerBI 中的(空白)值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!