Forum Discussion

ArslanManzoor's avatar
ArslanManzoor
Frequent Visitor
3 years ago
Solved

Filtering table 2 without relationship

Hi,   I have 2 tables, where table 1 contains material data, alongside 'Green zone' limits which differ based on column 2 (Results). Assuming I use these query tables as visuals in my dashboard, I ...
  • AntonioM's avatar
    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