Forum Discussion

TJK's avatar
TJK
Icon for Helper I rankHelper 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 c...
"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
        )
    )
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Color =
IF(
    SELECTEDVALUE('Transactions Export'[Lender])<>"COMP" && NOT(ISBLANK([Transactions])),
    RANKX(CALCULATETABLE(
        ALLSELECTED('Transactions Export'[Lender])),
        [Transactions],,,Dense
    )
)