Forum Discussion

TJK's avatar
TJK
Helper I
2 years ago
Solved

Conditional Formatting Only Active for Specific Column Value

I've created a row based conditional formatting DAX formula, but I don't want the conditional formatting to be active for the "Lender" column where Lender="COMP"

 

 

Is there anyway that I can get my formula to ignore the values that fall under "Comp" so that they are not highlighted in any colors? In other words, I only want the "RF" values to be highlighted in colors.

 

Below is more formula:

 

Color =
IF(
    NOT(ISBLANK([Transactions])),
    RANKX(CALCULATETABLE(
        ALLSELECTED('Transactions Export'[Lender])),
        [Transactions],,,Dense
    )
)
"DAX "
@Conditional Formatting
Conditional Formatting
  • lbendlin's avatar
    lbendlin
    2 years ago
    Color =
    IF(
        SELECTEDVALUE('Transactions Export'[Lender])<>"COMP" && NOT(ISBLANK([Transactions])),
        RANKX(CALCULATETABLE(
            ALLSELECTED('Transactions Export'[Lender])),
            [Transactions],,,Dense
        )
    )

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    Color =
    IF(
        SELECTEDVALUE('Transactions Export'[Lender])<>"COMP" && NOT(ISBLANK([Transactions])),
        RANKX(CALCULATETABLE(
            ALLSELECTED('Transactions Export'[Lender])),
            [Transactions],,,Dense
        )
    )