Forum Discussion

tomgag's avatar
tomgag
Resolver I
8 years ago
Solved

IF statement and how to avoid blanks

Hi All,   I have very simple task but it seems to me that it is an issue with Power BI.   I have a looped IF however when there is no value it gives me BLANK as oppose to 0.    Measure= IF('Tab...
Need Help
  • tomgag's avatar
    tomgag
    8 years ago

    The answer is rather easy.

     

    I added a measure with the simplest code possible.

     

    Measure2=sum('Table1'[Measure]) + 0
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

Where did you add the 0, if you add it as shown below it should display 0.

 

Measure= IF('Table1'[Col A] <> 0, 'Table1'[Col A],
                     IF('Table1'[Col B] <> 0, 'Table1'[Col B],
                         IF('Table1'[Col C] <> 0, 'Table1'[Col C],
                             IF('Table1'[Col D] <>0,'Table1'[Col D],
                                IF('Table1'[Col E] <> 0, 'Table1'[Col E], 0)
                                   )
                                 )
                             )
                       )+0

Thanks
Raj

 

tomgag's avatar
tomgag
Resolver I
8 years ago

The answer is rather easy.

 

I added a measure with the simplest code possible.

 

Measure2=sum('Table1'[Measure]) + 0