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)
I agree having the zero makes the visuals look more elegant. Blank is go to know there is an error, but that doesn't make sense for a visual.
RE: Count should return 0 instead of (Blank)
That could be a option by Element. Some visuals don't need this option and additionnal Zero could be just noise but on some visuals, turning on this option could be a great way to get niciest results.
RE: Count should return 0 instead of (Blank)
Yep adding 0 at the end of the measure worked @craig
RE: Count should return 0 instead of (Blank)
THIS IS URGENT PLEASE!
RE: Count should return 0 instead of (Blank)
I need a solution for displaying 0 instead of blank () in card visualization
RE: Count should return 0 instead of (Blank)
You can try Measure = Count() + 0
RE: Count should return 0 instead of (Blank)
This is a must!
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.
RE: Count should return 0 instead of (Blank)
Hello @Scott Sugar - do you mind sharing what the DAX would look like for that?
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