Forum Discussion
Filtering table 2 without relationship
- 3 years ago
Hi ArslanManzoor ,
One option is to use a measure to filter the second table, comparing the values of results with the selected limits from the first table.
Within Limit = IF ( SELECTEDVALUE('Table 2'[Results]) <= SELECTEDVALUE('Table 1'[Green zone upper limit]) && SELECTEDVALUE('Table 2'[Results]) >= SELECTEDVALUE('Table 1'[Green zone lower limit]) , 1, 0)This will give you
and
Then add a visual filter to only show the 1s
And now you have
Alternatively, you could use Power Query to create a list of allowed values (within the limits)
Add a custom column in Table 1
{[Green zone lower limit]..[Green zone upper limit]}Which gives you a list of the range, that you could then expand and link to Table 2 on Table 2[Result]
This might be many to many but you can set the filter direction to be single
Which would give you the same result
Hi ArslanManzoor ,
One option is to use a measure to filter the second table, comparing the values of results with the selected limits from the first table.
Within Limit = IF ( SELECTEDVALUE('Table 2'[Results]) <= SELECTEDVALUE('Table 1'[Green zone upper limit]) && SELECTEDVALUE('Table 2'[Results]) >= SELECTEDVALUE('Table 1'[Green zone lower limit]) , 1, 0)
This will give you
and
Then add a visual filter to only show the 1s
And now you have
Alternatively, you could use Power Query to create a list of allowed values (within the limits)
Add a custom column in Table 1
{[Green zone lower limit]..[Green zone upper limit]}
Which gives you a list of the range, that you could then expand and link to Table 2 on Table 2[Result]
This might be many to many but you can set the filter direction to be single
Which would give you the same result