Stephane Viot on 07 Oct 2015 23:52:58
Count of should return 0 instead of '(Blank)' (looks better on a Dashboard)
Administrator
You can do this with the COALESCE function: https://docs.microsoft.com/en-us/dax/coalesce-function-dax. For example:
= COALESCE(SUM(FactInternetSales[SalesAmount]), 0)
- Comments (54)
RE: Count should return 0 instead of (Blank)
The blank is certainly very annoying and an option to show blank as 0 or - or whatever we want to would be great.
Not sure exactly how the process works but this is perhaps something a community member can contribute to given that's an option now.
RE: Count should return 0 instead of (Blank)
what is this, europe before 1202 (when fibonacci began using 0 in his mathematics)?
RE: Count should return 0 instead of (Blank)
Do a calculation 0 + count of
RE: Count should return 0 instead of (Blank)
I agree
RE: Count should return 0 instead of (Blank)
Fully agree with most comments below. Please guys, this is such a simple change to make. You can't use the basic tools for simple counts, where a zero value will result in (blank) being displayed on screen. Having to define a custom measure for each one of these seems like a lot of work for something that should be this simple.
Please just provide the option to show 0 as the number zero or the text (blank). It's that simple.
RE: Count should return 0 instead of (Blank)
really helpful function. such as line chart
RE: Count should return 0 instead of (Blank)
Count with no Blanks = IF(DISTINCTCOUNT(Table[Value]) = BLANK () ,0,DISTINCTCOUNT(Table[Value]))
RE: Count should return 0 instead of (Blank)
This is a redundant request with 16587064. Please fix & close both!
RE: Count should return 0 instead of (Blank)
Hi all,
sorry if this has already been discussed, but I am quite new to Power BI and I need some help with cards; I am using an average to show value in cards which are linked to slicers; the issue is that if there are no data for a certain brand selected, then the card shows "blank" which is not ideal to see. Is there a way to change this "blank" to either zero or "no data"?
Thank you for your help
RE: Count should return 0 instead of (Blank)
I agree with previous user comments, when using external clean datasets and using the count feature from Power BI it would be nice to have the option to return "Blank" or "0" instead of a simple default to "Blank".
For dashboards displays that are number intensive displaying the word "Blank" tends to lead the intended audience to think that there is an issue with the dataset.
Thanks.