Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
4 years ago
Solved

conditional formating for measure inside a matrix

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 accordi...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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] ) ) )
    )
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

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's avatar
    lawada
    Icon for Helper III rankHelper III
    4 years ago

    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's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      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's avatar
        lawada
        Icon for Helper III rankHelper III
        4 years ago

        now its working thank you