Forum Discussion

twofingertyper's avatar
twofingertyper
Helper III
1 year ago
Solved

How to include an additional factor in a table to table relationship?

Hi all,   I have a product table which lists things in levels (1, 2, 3, 4 and ALL) and then a list of Companies who also have levels (1, 2, 3, 4).    What I am struggling with is how to make a p...
Need Help
  • anmolmalviya05's avatar
    anmolmalviya05
    1 year ago

    Hi twofingertyper, I hope you are doing good.

    Please try below approach:
    you can use a DAX measure to dynamically display "ALL" products alongside Company-specific products.

    DisplayProducts =

    IF(

    SELECTEDVALUE('Product'[Level]) = "ALL" ||

    SELECTEDVALUE('Product'[Level]) = SELECTEDVALUE('Company'[Level]),

    1,

    0

    )

    Filter your table visual by this measure (DisplayProducts = 1).

twofingertyper's avatar
twofingertyper
Helper III
1 year ago

This one works very well - thank you