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 and one value based on envrionement
if I have login to DEV and value will be Dev
| ENV |
| Dev |
Now, I want filter out Alert table on Env column based on value from Environment table
I dont want to use filter on report pages, as it will manual work while doing deployment.
3 Replies
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]) ) )
amitchandak
both ways are helpful
which will be fast according to you?Hi Pawanw511,
Have you solved your problem?
I think you could directly create a measure, which is much more faster.
