Forum Discussion

cheezy's avatar
cheezy
Helper I
6 years ago
Solved

Conditional formatting based on two values/fields in separate tables

trying to work out how i can achieve this and apply a conditional format (new to DAX):   for example two tables:   table 1                 table 2 Field 1                     Field 1            ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi cheezy ,

    If the two tables only have one column, maybe you can create a measure like this:

    Measure = 
var _t1 = SELECTEDVALUE(Table1[Field1])
var _t2 = SELECTEDVALUE(Table2[Field1])
return
IF(
    ( _t1 = "A" && _t2 <=10 ) ||
    ( _t1 = "B" && _t2 <=15 ) ||
    ( _t1 = "C" && _t2 <=20 ),
    "Value1",
    IF(
        ( _t1 = "A" && ( _t2 >10 || _t2 < 20 ) ) ||
        ( _t1 = "B" && ( _t2 >15 && _t2 < 30 ) ) ||
        ( _t1 = "C" && ( _t2 >20 && _t2 < 40 ) ),
        "Value2",
        "Value3"
    )
)

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

cheezy , does these tables have any common field. If not then you have to use crossjoin and summarize

 

example

table2 = SUMMARIZE(filter(CROSSJOIN(Sheet1,Table),Table[Date]>=(Sheet1[last Date]) && Table[Date]<=(Sheet1[Start Date])),Sheet1[ID],Sheet1[Name],table[Status],Table[Date],Sheet1[Start Date],Sheet1[End Date])

 

Filter is optional. you can create the column in summarize as per need

 

or selectcolumns and crossjoin

https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax