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 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'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] ) ) )
    )
)

4 Replies

  • 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] ) ) )
    )
)