Forum Discussion

ravirayala4252's avatar
ravirayala4252
Helper I
3 years ago
Solved

Highlight the values in Table A from Table B - Conditional formatting !..

Dear experts 
I have a Situation here, Please help me with Solution. 
I have created 2 table visuals, which are connect through 2 bridge table.

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  ravirayala4252 ,

     

     

    Here are the steps you can follow：

    1. Create measure.

    Flag =
var _columnB=MAX('TableB'[Order ID])&""&MAX('TableB'[Material ID])
var _columnA=SELECTCOLUMNS('TableA',"Group",'TableA'[Order ID]&""&'TableA'[Material ID])
return
IF(
    _columnB in _columnA,"red","white")

    2. Select [Actual Hours] – Conditional formatting – Background color.

    3. Result:

     

     

    Best Regards,

    Liu Yang

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    ravirayala4252 , Create a new measure  for table 2

     

    Countrows(filter(Table2,Table2, Table2[Material] in values( Table1[Material] ) &&  Table2[Order] in values(Table1[Order] )  ))

     

     

     

    Countrows(filter(Table2,Table2, Table2[Material] && "-" && Table2[Order] in  selectcolumns(Addcolumns(Summarize(Table1, Table1[Material] ,Table1[Order] ) , "_1", Table1[Material] && "-" && Table1[Order] ), "_2", [_1]) ))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  ravirayala4252 ,

     

     

    Here are the steps you can follow：

    1. Create measure.

    Flag =
var _columnB=MAX('TableB'[Order ID])&""&MAX('TableB'[Material ID])
var _columnA=SELECTCOLUMNS('TableA',"Group",'TableA'[Order ID]&""&'TableA'[Material ID])
return
IF(
    _columnB in _columnA,"red","white")

    2. Select [Actual Hours] – Conditional formatting – Background color.

    3. Result:

     

     

    Best Regards,

    Liu Yang

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

  • ravirayala4252's avatar
    ravirayala4252
    Helper I
    2 years ago

    Hai amitchandak Anonymous 

    I think it is better to rephrase my question.
    I have 2 tables with are not directly connect, which are connect throught 4 bridge tables. i did this to avoid many to many relation.
    I have created 2 table visuals from these 2  tables say A,B.
    Table A & B have common columns (Order ID , Material ID & Market ID).
    Now i want to highight the matching b/w two table visuals. I used the following measere but it's not wotking for me.please suggest me appropreated on.
    FYI, Below measure error i'm getting was not able to see the table B in related function .

    1. MatchingHighlight =
    IF(
    COUNTROWS(
    FILTER(
    ALL(DateTable, OrderIDTable, MaterialIDTable, MarketIDTable),
    COUNTROWS(
    FILTER(
    Table1,
    Table1[Order ID] = RELATED(OrderIDTable[Order ID]) &&
    Table1[Material ID] = RELATED(MaterialIDTable[Material ID]) &&
    Table1[Market ID] = RELATED(MarketIDTable[Market ID]) &&
    Table1[Date] = RELATED(DateTable[Date])
    )
    ) > 0
    )
    ) > 0,
    "Match",
    "No Match"
    )