Forum Discussion

TylerVono's avatar
TylerVono
Helper III
3 years ago

If IsBlank Not Working

Hello, My If IsBlank statement is not working, any ideas? I just want any blanks in the column to show a 0:

 

What am I doing wrong?

 

 

 

2 Replies

  • TylerVono ,

    Can you try a

    measure = Sum('MOM Stocking report'[AgreementLevel]) +0

     

    Ideally, your column should have worked. But need to check data

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Hey amitchandak , It worked thank you. But I just wonder why my original statement didnt work.... any ideas?