Changing blank to 0

[Anonymous]

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?

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

COUNTROWS ( SalesOrders )  + 0