conditional formating for measure inside a matrix

[lawada]

i have created a cohort with a matrix visual  where :

rows= month 

columns= difference between current month and previous month

values= measure [total users]

i want the color to change according to the measure value each month 

note that  the first value in the matrix is blank and i want the formating to start from value 0 

i have created this measure and used in the conditional formating 

 total users formating =

IF(

MAX(table[months_diff])<>BLANK(),

CALCULATE(

RANKX(

ALLSELECTED( table[months_diff]),

[total users]

),

KEEPFILTERS(table[months_diff] <> BLANK())

)

)

but its not including the value 0 in the formating

[AlexisOlson]

I think the problem is that 0 <> BLANK() evaluates as False.

See if this works any better:

total users formating =
IF (
    NOT ( ISBLANK ( MAX ( table[months_diff] ) ) ),
    CALCULATE (
        RANKX ( ALLSELECTED ( table[months_diff] ), [total users] ),
        KEEPFILTERS ( NOT ( ISBLANK ( MAX ( table[months_diff] ) ) ) )
    )
)

[lawada]

im getting this error when using the measure

The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

[AlexisOlson · Accepted solution]

I accidentally copied and pasted the MAX into the filter part.

See if this works:

total users formating =
IF (
    NOT ( ISBLANK ( MAX ( table[months_diff] ) ) ),
    CALCULATE (
        RANKX ( ALLSELECTED ( table[months_diff] ), [total users] ),
        KEEPFILTERS ( NOT ( ISBLANK ( table[months_diff] ) ) )
    )
)

[lawada]

now its working thank you