Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tomgag
Resolver I
Resolver I

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('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)))))

 

I tried to add + 0 at the end but it did not work,

 

1 ACCEPTED SOLUTION

The answer is rather easy.

 

I added a measure with the simplest code possible.

 

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

 

The answer is rather easy.

 

I added a measure with the simplest code possible.

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.