Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |