How to set color condition from 2 table

[manike]

I would like to set the color condition from 2 table which have already set the relationship betweem them. However, I have tried some times but didn't work. (it seems only set the condition from 1 table only)

Here is my idea on color condition from 2 table.

Table1[Value] = 'A' and Table2[Value2]= 'abc'  then 'Red'

Table1[Value] = 'B' and Table2[Value2]= 'cdf'  then 'Yellow'

Table1[Value] = 'C' and Table2[Value2]= 'cdf'  then 'Green'

I tried the below but keep fail.

color = SWITCH(

TRUE()

,Table1[Value] = 'A' and Table2[Value2]= 'abc'  < 1, "#f44242"

,Table1[Value] = 'B' and Table2[Value2]= 'cdf', "#f4f142"

,Table1[Value] = 'C' and Table2[Value2]= 'cdf', "#5ff442",

"#f44242"

)

Would you all please help? Thanks!

[amitchandak · Accepted solution]

@manike , If you creating a new column then you have brought column from one table to another

say you want bring to Table 1 and table 1 is on many side in 1-M relation

then you can use

related(Table2[Value2])

otherwise try

Maxx(relatedtable(Table2),Table2[Value2])  //you can use minx, countx or sumx as per need

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8