Condditional formating based on another table

hi Anonymous

Thank you for your qick response. I was affraid that woudl be the case.

Isnt there a way how to do this with help of DAX.

Lets say i have the total sale data in a different table where i would need to calculate it first

- something like

john sale = calculate (sum(table all sale,table all sale[2015]),filter(tabletable all sale[employee]="john") 

and then

= if(table#2[2015]="Bonus", format("john sale", "red", text), "john sale"

i mean this is very simplistic but i am still very new to dax .. but you might get the idea and maybe you can help

thank you