Show Cells with conditional formatting but null value

[helenbjones]

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.

[v-cherch-msft · Accepted 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,