Forum Discussion
How to include an additional factor in a table to table relationship?
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).
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).
This one works very well - thank you
Great to hear that it worked !!
Please mark it as a solution so that it will be helpful for other! Appreciate your Kudos !!Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in