Count + 0

[bdehning]

I have column chart by month year that works great when I use a Y-Axis Count Field.    

If I add a +0 to my count to account for 0 count months, I see 0 months going back to 1963.   I am trying to see most recent yeae data and maybe another year back.  I have filters for that.  

My filters to restrict years do nothing.   

What can I do as this is Count Measure - 

Count + 0 = CALCULATE(DISTINCTCOUNT(LossRun[Claim Number])) +0

[danextian · Accepted solution]

Hi @bdehning ,

Power BI treats 0 and blank differently.  If you add  0 to an aggregation, Power BI will show 0 for rows which values are supposed to be blank so, for example, the data doesn't in exist in Year 1963 until 1980, they will return 0 which may not be what you want. You must add a condition to your formula when to return 0. Example:

IF ( SELECTEDVALUE ( dates[year] >= 1990 ), [my measure] + 0 )

This WILL return at least 0 if the year is from 1990 onwards.

[Ashish_Mathur]

Hi,

Why are your filters not working?  Also, you can simplify your measure to:

Measure = coalesce(DISTINCTCOUNT(LossRun[Claim Number]),0)

[Ritaf1983]

Hi @bdehning 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523