CODEWITHSUNDEEP
powerbipowerbi-desktop
stefbmt
stefbmt

Reputation: 111

Replace (Blank) values in PowerBI with Zero

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.

My Source Data looks as follows:

Full Name | ID | Location
Patient A | xxxxxA | ITU
Patient B | xxxxxA | IDU

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:

PowerBI - Replace Zeros with Blanks

PowerBI Differentiate BLANK value and 0 value

Replacing Blank values with Zero using Dax

Any help would be appreciated!

Upvotes: 0

Views: 661

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

If your KPI measure is numeric, then you can usually just add + 0 to the measure since

BLANK() + 0 = 0

Upvotes: 2

Related Questions