Reply
IeuanG
Frequent Visitor

Changing blank to 0

Hello, 

 

I have a matrix in my Power Bi report  that shows Sales Orders by year. However, some products have no sales in some months and the DAX I currently use returns blanks instead 0. 

 

I need the DAX to return 0 instead of blank. My current DAX is  COUNTROWS(SalesOrders

 

Can anyone help?

 

 

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @IeuanG 
Please try

COUNTROWS SalesOrders )  + 0

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @IeuanG 
Please try

COUNTROWS SalesOrders )  + 0

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)