Forum Discussion

Sivkram's avatar
Sivkram
Regular Visitor
2 years ago
Solved

Filtering on non dimension field

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. 

 

  • 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

1 Reply

  • 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