Conditional formatting of values of one matrix with respect to the values in another matrix

[Abysshek]

Hi everyone,

I'm trying to highlight the values which are lower than the target value with red and above the target value with green.

P.S. the TAT 4,7,13D are measures of say Table A and Target is the column of Table B. Is there a way to compare both?

Thanks,

Abhishek

[Abysshek]

I've tried this and got this result but it is valid for first category only.

TAT 13D highlight = IF(

    CALCULATE([TAT 13D]<SELECTEDVALUE('Target FY22'[Target]),'Target FY22'[Parameter]=">13D",'Target FY22'[Category]="LCD"),"#FF0000","#008000")

TAT 7D highlight = IF(

    CALCULATE([TAT 7D]<SELECTEDVALUE('Target FY22'[Target]),'Target FY22'[Parameter]="TAT1_7D",'Target FY22'[Category]="LCD"),"#FF0000","#008000")

TAT 4D highlight = IF(

    CALCULATE([TAT 4D]<SELECTEDVALUE('Target FY22'[Target]),'Target FY22'[Parameter]="TAT4D",'Target FY22'[Category]="LCD"),"#FF0000","#008000")

[ChiragGarg2512]

-> If the target value is constant, use rules in background coloring in the cell element.

-> If the target is variable, create a measure using the switch statement. And apply it to the field format style.

[Abysshek]

Can you suggest the dax for second one