How to make filter for many to many relationship

[bourne2000]

Hi

I am having below two tables one is lookup and another one is Agent Summary

Both tables are connected with Email ID and it's many many relationships. I used Last First name from the Lookup table and created a report with Agent summary data. Lookup table has 

I want to have a filter Last First, but only filters should be having required names from the agent summary. Can anyone advise?

[v-yangliu-msft]

Hi  @bourne2000 ,

Only one field can be used as a connection relationship between two tables, not two at the same time. You can try to use the field filter on the page.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Best Regards,

Liu Yang

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

[lbendlin]

That's not a very good design but should work as you describe. What have you tried and where are you stuck?