0 Data - Translate this to 0 count on graph

Nolan79 · ‎08-18-2023

Hi everyone! To start, I am very new at this and learning as I go, please understand I may not grasp your recommendation(s) right away!

The problem I currently face is I'm pulling data from several sources, running calculations, however, I have 0 values/data in 1 month, and the graph does not reflect this as a 0 count, but instead a null(missing). For further context, the 'Errors' is being "counted" by a value within that month group, however, again, there is nothing within that month. Here are the screenshots for understanding.

Thanks in advance everyone!

parry2k · ‎08-22-2023

@Nolan79 it is not as easy as you think, this blog/video will help

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

danextian · ‎08-18-2023

Hi @Nolan79 ,

It seems that you have used either COUNT or COUNT. Those functions exclude blank values. Instead, I'd use COUNTROWS( 'Table Name') to count for the rows if the goal is counting that number of rows within a table regardless of the uniqueness of values in a column.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Nolan79 · ‎08-22-2023

Hey @danextian, thanks for the input. So, I believe the problem is that it is counting the amount of rows by Month. Therefore, the month of July is a missing value in the row and does not translate it into 0 on the visual. I'm not good at coding(DAX) whatsoever, but I did try to do some IF measures to see if I could get it to push out the value I'm looking for, no luck. Unfortunately, whether it is COUNT or COUNTROWS, it does not bring in the 0 count.

danextian · ‎08-22-2023

If you're using a separate dates table, you can write a measure that returns 0 if the actual value is blank.

Value2 =
IF ( ISBLANK ( SUM ( 'Fact'[Value] ) ), 0, SUM ( 'Fact'[Value] ) )

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.