Set analysis in Pivot with no result Null Value

[RC_121985]

Namaste 🙏,

I am trying to color the pivot back ground based on the result. All working good, but some values resulting Null values and as all know we can't have color to null and need to have 0 or other values to achieve it.

My expression in Measure : to give the count of Open status by different dimension in Pivot  

Count({<DATE={"<=$(=(DATESELECT))"},STATUS={'OPEN'}>}COUNTKEY) 

(*DATESELECT is Variable Key)

My Color expression in Background Color :

If(GROUP='GROUP1','#ffe53c',
If(GROUP='GROUP2','#FFA726',
If(GROUP='GROUP3','#EF8383',
If(GROUP='GROUP4','#BE2D2D',
If(GROUP='GROUP5','#7E0E0E',White())))))

My expression in Measure resulting in null values for some dimensions for which my expression in Color not able to color it.

So, how do i change my expression in measure to result the null to Zero. 

 Thanks,

[Digvijay_Singh]

Not sure if I understand the problem fully but you may try coalesce function if available in your release - 

something like  - Coalesce(Count({<DATE={"<=$(=(DATESELECT))"},STATUS={'OPEN'}>}COUNTKEY),0) 

Or ALT(Count({<DATE={"<=$(=(DATESELECT))"},STATUS={'OPEN'}>}COUNTKEY),0)