Forum Discussion
Filter columns from two or more tables
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!!!
Memorable Membercmpbn
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!!!
Instead of manually passing city = chicago and sal > 500.
is there a way to to parameterized the hard coded values?
- NaveenGandhi
cmpbn
For City you can use a slicer of city name[create a city dim table and keep this disconnected], For salary create a numeric parameter. Use selectedvalue function to pass both of these to the measure. It will look something like below.
calculate(count(emp),city=selected value of(city_fromdim table)&&salary>selectedvalue(numeric_parameter))