Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Replacing Blanks with 0 - Adding +0/ new measure not working!

Hello, 

 

I have been trying to replace Blank values as 0 in my matrix visualisation. I have tried using +0 in a new measure and dax functions but no luck. Below is an example of my data and what i am trying to do. Please share your ideas!!

 

DirectionCategoryDate
I117-Jun
B218-Jun
B317-Jun
I118-Jun
I220-Jun
I421-Jun
B519-Jun

EXAMPLE.PNG

I am trying to add values as "0" when the count of category for a specific date is null. 

 

Thanks in advance!

6 REPLIES 6
Anonymous
Not applicable

Adding 0 to a number/measure (like COUNT) always forces the display of a number. ALWAYS. The fact that you can't see 0's in your matrix points in a different direction. I'd check the formatting of the values in the table. Maybe 0's are formatted as BLANKS by the matrix? Can you check some other visuals?

 

Best

Darek

Cmcmahan
Resident Rockstar
Resident Rockstar

What is the measure you are currently using to fill this table?  What measures using the +0 trick have you tried?

Anonymous
Not applicable

Hi @Cmcmahan 

I have used the following dax:

 

count = count([category]) + 0

count = if(isblank(count([category)),0,count([category]))

Child Count = 
VAR rowcount =
    COUNTROWS ( Child )
RETURN
    IF ( rowcount = BLANK (), 0, rowcount )​
count of category = IF(COUNTX(VCCdata,VCCdata[Category]) = 0, 0, COUNT(VCCdata[Category]))
ActualM =
IF (
    CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (),
    0,
    CALCULATE ( SUM ( Expenses[Actual] ) )
)

Using your first measure (count = count([category]) + 0), I was able to get this:

snipa.PNG

 

Could you share a screenshot of the fields you have in your Rows/Columns/Values buckets in the visualization pane?

Anonymous
Not applicable

example 1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

I have also used the same measure in the above screenshot. I tried performing the same for various sets of data i have but still end up getting the same. If i am changing count = count([category])+0 to count=count([category])+1, only the fields in the table withvalues get updated and the blank values remain the same. 

Anonymous
Not applicable

[Category Count] = DISTINCTCOUNT( T[Category] ) + 0 

Always use the name of the table in front of the column. ALWAYS. And never do that in front of measures. NEVER.

 

The behavior you're talking about is abnormal. Please restart Power BI.

 

Best

Darek

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.