Filtering on non dimension field

[Sivkram]

Hi, 

I'm relatively new to Power BI and I have a question on modelling / filtering data. 

We have budgets that have a planned value. A budget can have 0..n linked workers. 

My data model (simplified) looks like: 

Now I want to create a visual showing planned value by budget. That works fine. But what I would like to achieve is that I'm able to add some filter on my report where I can select a worker and that should show me all budgets that are linked to that worker. 

I can't figure out how to get this to work so what should I do to achieve this. 

Example:

Left table shows the planned value by budget; right table shows the workers linked to budget. In the filter I filter on Julia Funderburk. Richt table shows all budgets with that person linked. I want the left table to also show only budgets that have that worker linked. 

[amitchandak · Accepted solution]

@Sivkram , Assume Name is selected from budget workers

Create a new measure

Countrows(filter(PlannedValue, PlannedValue[BudgetRecodID] in Values(budgetworkers [BudgetRecodID] ) ) )

and use that in visuals.

Or make all joins as bi-directional