Using values to compare from 2 tables in DAX Filter

Hi MikhailGG ,

Here is my sample data:

 

You can use this DAX to create a calculated table in table Benchmark Categories

Dog_ID_Count = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[Value] >= 'Benchmark Categories'[Lower_Level] &&
        'Table'[Value] <= 'Benchmark Categories'[Upper_Level]
    )
)

And the final output is as below:

 

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.