Select value from a table based on combination of selected values from other table.

[Wolfgang7]

Hi all,

I would appreciate your help with the following:

I have a table which holds comments explaining the differnce between two excercises for a set of concepts (table COMMENT):

I also have a table which holds the exercises, including an order for displaying it in slicers (table EXERCISE):

The two tables can have a relationship if needed, I'm guessing there would need to be two relationships between exercise  and excercise a and b.

I have a slicer with the EXCERCISE table where I can select one or more than one excercise for comparison purposes in a waterfall chart.

I need a card to display the correct comment when two excercises are selected, so if I select "spring" and "summer" the output for "item 1" should be "More sales".

I can't use two different fields to select excericses (which would be a lot easier for this comment problem), like a table EXERCISE A and EXCERCISE B because of how all the other visuals are set up; it has to be based off the same EXCERCISE table.

Please let me know if you can think of a way to achieve this.

Thanks a lot for any help.

[Ashish_Mathur]

Hi,

In the Query Editor, select the last 2 columns of the first table, right click and select "Unpivot Other Columns".  Create a relationship (Many to One and Single) from the Attribute column of Table1 to the exercise column of Table2.  Now build your visual/slicers.