Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, need some help please. I have a matrix with values in and conditional formatting based on another value. I need null values to also show if the conditional formatting value is valid. So, for example, the sum value is 0 but the conditional formatting is based on a differenct column which has a value of 1 and so should give a geen cell. However, I am not getting this empty green cell and I need to.
Solved! Go to Solution.
Hi @helenbjones
You may try to create a measure with ISBLANK function.[SumValue] is 0.For example:
Measure = IF ( ISBLANK ( SUM ( Table1[Column1] ) ) || SUM ( Table1[Column1] ) > [SumValue], 1 )
Regards,
Hi @helenbjones
You may try to create a measure with ISBLANK function.[SumValue] is 0.For example:
Measure = IF ( ISBLANK ( SUM ( Table1[Column1] ) ) || SUM ( Table1[Column1] ) > [SumValue], 1 )
Regards,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |