Forum Discussion
Solved
Filter columns from two or more tables
I have two tables Employee and Department, and the common column is deptno. I have been trying to calculate the number of employees from deptno 20 whose earns more than 550. I palyed with the FILTE...
cmpbn
Create a lookup column and use it to filter EMP table. I have updated the PBIX with altered solution.
Does this help?
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
cmpbn
Create a lookup column and use it to filter EMP table. I have updated the PBIX with altered solution.
Does this help?
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
Thanks, it worked.
I just realised this could have been done using CALCULATE function which reestablishes the relation ship between the tables.