CODEWITHSUNDEEP
powerbidaxmeasure
Wondarar
Wondarar

Reputation: 183

Advanced filtering "show items when value is 0" results in (blank) - how to replace it with 0?

I have a card, that shows the COUNT of service requests, which consists of "opened" requests and "closed" requests. So in this case, there are 2 requests in total whereas 2 are in status "open" and 0 "closed":

enter image description here

The value comes from column "SR Number"

enter image description here

The setting in power bi is: "PKT" with value SR Number is filtered by column "hierarchy" "open" with value SR Number is filterd by column "hierarchy" AND column "request status" as filter (NEW) "closed" with value SR Number is filtered by column "hierarchy" AND SHOULD BE fed by "request status" as filer (CLOSED) BUT THERE ISN'T ANY

enter image description here

When I set the advanced filter I get (blank) as value.

enter image description here

I now know that this is Power Bi default behaviour and I read some articles on how to replace it with 0. Some recommend a new measure or adding DAX code.

I tried both but still don't get it solved, respectively don't get it at all.

Upvotes: 0

Views: 1789

Answers (1)

Alan K
Alan K

Reputation: 81

Add new Measure:

PKT Count Formatted = FORMAT(COUNT('Table'[PKT]), "0")

And use it as a field in the viz

Upvotes: 1

Related Questions