topic Re: Conditional Formatting Only Active for Specific Column Value in DAX Commands and Tips

Conditional Formatting Only Active for Specific Column Value

TJK — Wed, 10 Jul 2024 19:27:44 GMT

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

)

)

Re: Conditional Formatting Only Active for Specific Column Value

lbendlin — Thu, 11 Jul 2024 00:37:40 GMT

Color =

IF(

SELECTEDVALUE('Transactions Export'[Lender])<>"COMP" && NOT(ISBLANK([Transactions])),

RANKX(CALCULATETABLE(

ALLSELECTED('Transactions Export'[Lender])),

[Transactions],,,Dense

)

)