Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Replacing a blank with a 0

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. 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Based on what I get, a new measure

     

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

     

    But this might force left join

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

       

      I am recieving the below error

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

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

         

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

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.