Forum Discussion

mslino's avatar
mslino
New Member
2 years ago

Conditional formating using a Measure

Hi!

 

I created a measure to be used in a Matrix usinf the bellow code:

Measure 2 = IF (
    ISINSCOPE('Table[nm_mdld]),
        VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1
        VAR grade = SWITCH(TRUE, indx <= 0.01, "1",
                                indx > 0.01 && indx <= 0.05, "2",
                                indx > 0.05 && indx <= 0.10, "3",
                                indx > 0.10 && indx <= 0.20, "4",
                                indx > 0.20, "5")
    RETURN grade,
        VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1
        VAR grade = SWITCH(TRUE, indx <= 0.01, "1",
                                indx > 0.01 && indx <= 0.05, "2",
                                indx > 0.05 && indx <= 0.10, "3",
                                indx > 0.10 && indx <= 0.20, "4",
                                indx > 0.20, "5")
    RETURN grade
)

I would like to use the value in the Measure 2 e.g. (1,2,3,4,5) to change it´s cell color, but I was unable to find a solution. I´m newbe in DAX .

Regards.

@conditional format
@Conditional Formatting
Conditional Formatting
DAX

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    instead of returning "1"  you can return the name of the color.

     

    Measure 2 = IF (
    ISINSCOPE('Table[nm_mdld]),
        VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1
        return SWITCH(TRUE, indx <= 0.01, "red",
                            indx <= 0.05, "pink",
                            indx <= 0.10, "yellow",
                            indx <= 0.20, "orange",
                            "green")
)

     

    and then color by "field value".