Measure that returns conditional formatting based on rank and ID

[Anonymous]

Hello,

I have a measure which I have made to apply condtional formatting to a table. It ranks the months in the table and then applies the conditional formatting based on an if statement. 

 

I am trying to add another if statment which will change one of the rows of formatting above based on ID as well, the second row  to anly be shaded to september. The ID i am using is the right one, but I can't figure out why it wont work.

Any help it greatly appreciated.

[amitchandak]

@Anonymous , if this a measure you can use if max(Table[ID]) =10 in the condition

example

Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)

[Anonymous]

Hi @amitchandak,

Is this what you mean?

 it still gives the same result unfortunately.

I tried using a switch instead of IF statement but got the same result.

thanks.