Forum Discussion
Count + 0
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 -
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.
3 Replies
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.
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/1447523Hi,
Why are your filters not working? Also, you can simplify your measure to:
Measure = coalesce(DISTINCTCOUNT(LossRun[Claim Number]),0)
