how to return tems with no data as 0 instead of blanks

[Anonymous]

Hi people, i need a little help with this pace of sales:

In the measures 'Otros Columnas' and 'Acumulado otros canales'.

I need them to return 0 instead of empty.

But if I use an if statement it doesn't work and break me all the measures.

what can i do? any suggest? 

[ribisht17]

HI @Anonymous 

Please share the file for better analysis and response, meanwhile I have shared the below link that may help

https://community.powerbi.com/t5/Desktop/Replacing-Blanks-with-quot-NA-or-0/m-p/2874852

Regards,

Ritesh

[DOLEARY85]

Hi,

do you have a copy of the PBIX file i could look at?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍