Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
IeuanG
Frequent Visitor

Changing blank to 0

‎06-09-2023 05:35 AM

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?

 

 

 

 

Message 1 of 2
170 Views
0
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

‎06-09-2023 06:52 AM

Hi @IeuanG 
Please try

COUNTROWS ( SalesOrders )  + 0

View solution in original post

Message 2 of 2
138 Views
0
1 REPLY 1
tamerj1
Super User
Super User

‎06-09-2023 06:52 AM

Hi @IeuanG 
Please try

COUNTROWS ( SalesOrders )  + 0

Message 2 of 2
139 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All