How to filter a chart based on multiple table relationships?

[Anonymous]

Hey All,

I'm new to Power BI and was wondering how i could create multiple relationships between 2 tables. My data model looks like this

I have a chart created (incorrect because of relationships) and want to display Total Users and Users from the Traffic Data table but be able to filter by Value_Prop field that exists in both tables. I've used the Value_prop field from the Txn Data table as the primary filter as it filters other charts in the dashboard.

How can i filter the above chart on both the Date from the calendar table and Value_Prop from Txn Data table with measures from Traffic Data table?
 

[v-lionel-msft]

Hi @Anonymous ,

You have got the correct result, haven't you?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @Anonymous ,

You need to replace [Users] and [Total Users] with meatures and complete the correct aggregation by adding filters in the measures.

Do you mind sharing your .pbix file? If yes, please show the sample data.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey! 

You can access the files here: https://drive.google.com/drive/folders/1WECvC7FofNZLCiDBq4IH54fQK8WOOhg3?usp=sharing

I've created the visual. I want to filter the chart on both the Date from the calendar table and Value_Prop from Txn Data table with measures from Traffic Data table.