Replacing a blank with a 0

[Anonymous]

Good Afternoon All

I have a table on my Power BI as a visual. Is there a way i can make all the blank cells a ?

Please see the attached picutre. 

[v-jingzhang]

Hi @Anonymous 

Can you share a PBIX file which can reproduce this error (removing sensitive info)? We need to know more details about the table and columns to find the solution. You can upload the file to some cloud storage service like OneDrive and share the link here.

Additionally, see if below link can help solve the circular dependency error.

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@Anonymous , Based on what I get, a new measure

if(isblank([measure]), "A",[measure])

But this might force left join

[Anonymous]

@amitchandak thankyou, i assume i just add the new measure under 'Values'

I am recieving the below error

[amitchandak]

@Anonymous , close ) asfter isblank(Query[Instance])

if(isblank(Query[Instance]), "rto",isblank(Query[Instance])&"")

[Anonymous]

thankyou @amitchandak 

seems to be working better but still prodcuing an error.