Dynamic Tooltip Across Multiple Table

[Yin34]

Hi everyone, here is my struggle:

There are two data tables, 5 measures (not calculated columns), M1 to M5 are created in Table 1, the other 5 measures (not calculated columns), M6 to M10 are created in Table 2. There is no relationship between these two tables. Both tables have a date field, DateDTS. There is a one to many relationship from a date table, DateTB to Table 1 and Table 2 separately using DateDTS and DateDTS from DateTB. Then a trending visual chart (Matrix visual) is created showing the monthly trending of all ten measures in the same visual over time, DateDTS from the DataTB table is the column, M1 to M10 are in the Values section. M1 has a target range, good: 0 to 4, danger: 4 to 100. M2's target range is that good: 0 to 10, danger: 10 to 100. The rest of the measures also have their own target ranges. I would like to create a tooltip that shows the target range of the relevant measure when user hovering over a cell in the matrix visual. For instance, when hovering over to the cell of M1 on May of 2024 with a value of 5, the tooltip will show "good: 0 to 10; danger: 10 to 100". I've tried multiple approaches, but still couldn't make it. 

Thank you so much in advance!

[Deku]

You need a filter context.

If you create a field parameters will all the measures in. You can add extra columns to the field parameter for the good bad ranges. Add the field parameter to the matrix.

You can use the parameter as the drillthrough for the tooltip. On the tool tip you will have the good bad ranges from the field parameter table.