Forum Discussion
How to filter one table using column value from another table
Hello All, I have two tables using direct query Table Alert Report Name Env Alert Type Xyz DEV Issue LMN PROD Bug I have another table Environment, have only one column a...
Pawanw511 , You can simply Join them on ENV column and then table should filter other one.
Else you have create measure that can take the values of other tables
example
countrows(filter(Alter, Alter[Env] in values(Environment[Env]) ) )