Skip to main content

Power BI

Needs Votes

Count should return 0 instead of (Blank)

Vote (552) Share
Stephane Viot's profile image

Stephane Viot on 07 Oct 2015 23:52:58

Count of should return 0 instead of '(Blank)' (looks better on a Dashboard)

Comments (51)
Stephane Viot's profile image Profile Picture

a33aaa92 29ff-4b94-a178-8eedb6c46ecb on 05 Jul 2020 22:27:29

RE: Count should return 0 instead of (Blank)

THIS IS URGENT PLEASE!

Stephane Viot's profile image Profile Picture

9b78ff8d dd5d-4008-badb-78831f94e5e1 on 05 Jul 2020 22:26:19

RE: Count should return 0 instead of (Blank)

I need a solution for displaying 0 instead of blank () in card visualization

Stephane Viot's profile image Profile Picture

1f0dea6e cc2b-4095-b630-8d843f0bd1f5 on 05 Jul 2020 22:26:10

RE: Count should return 0 instead of (Blank)

You can try Measure = Count() + 0

Stephane Viot's profile image Profile Picture

5c8adad4 146b-4b38-94b0-409b902a843b on 05 Jul 2020 22:17:58

RE: Count should return 0 instead of (Blank)

This is a must!

Stephane Viot's profile image Profile Picture

d20835ff 6917-49e7-b06a-268bbb81e87b on 05 Jul 2020 22:17:36

RE: Count should return 0 instead of (Blank)

'@JadeD I used this DAX; IF(COUNTROWS('Today')=0,0,COUNTROWS('Today')) Where 'Today' is a filtered table.

Stephane Viot's profile image Profile Picture

27f167cd 757f-49cb-87a5-fe2526496545 on 05 Jul 2020 22:15:34

RE: Count should return 0 instead of (Blank)

Hello @Scott Sugar - do you mind sharing what the DAX would look like for that?

Stephane Viot's profile image Profile Picture

c820c4c5 c10d-e711-8107-5065f38a3bb1 on 05 Jul 2020 22:14:43

RE: Count should return 0 instead of (Blank)

Actually I've worked around this by creating a new measure and using a dax formula to do my count

Stephane Viot's profile image Profile Picture

c820c4c5 c10d-e711-8107-5065f38a3bb1 on 05 Jul 2020 22:14:35

RE: Count should return 0 instead of (Blank)

Would definitely prefer count to be 0 instead of (Blank).

Stephane Viot's profile image Profile Picture

bbbda08e cb79-4031-b140-771ce46481d1 on 05 Jul 2020 22:13:58

RE: Count should return 0 instead of (Blank)

i am having the similar problem

Stephane Viot's profile image Profile Picture

74f3ea1d 6a9d-4c66-b3e0-5e0eacf4b174 on 05 Jul 2020 22:08:50

RE: Count should return 0 instead of (Blank)

Yes. I'm having the same eyesore on my dashboard.