Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to Solution.
The answer is rather easy.
I added a measure with the simplest code possible.
Measure2=sum('Table1'[Measure]) + 0
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