Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace "blank" with 0

Hi Community   I know this have been posted so many times but have not found a solution that really works in my example. I hope you are able to help me.   I have created a Table visualization tha...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

     

    Download sample PBIX

     

    I've set up some dummy data and adding 0 to the measure gives me 0 when the result is blank.

     

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

So my suggestion to +1 the result of the CTR Measure is actually working.  It's just that your table is then behaving in ways that you don't want.  That's a different problem.

Looking at your data you have multiple Many-to-Many relationships on the ID field and the only relationship tieing a Sales Company to other tables is via Preferred Language.

So I'd say there is some issue(s) with the way your data is set up and the relationships between tables.

You might be better off starting another post and restating the issue which is when you return 0 from CTR the table messes up.

Regards

Phil