Relationship between three tables

[Anonymous]

Hi,

I think I have an issue regarding a relationship between three tables:

On the left you can see the list of our employees and then I have blurred out their sales. On the very right you can see a matrix with a list of the same employees and then the number of customer they have.

I want to be able to filter those matrixes through "month". At the moment you can see those data for the whole year. If I change the month it just changes the sales for this specific month but not the number of customers on the right - it still shows me the number of customers for the whole year.

These are my relationships. If I reactive the green relationship I am able to filter through "month" and I will get the number of customers for this specific month but then the SALES per employee remain the whole sales per year. I do not know how to make it possible to filter those two items 😞 Maybe you can help

[Pragati11]

Hi @Anonymous ,

Try making your relationships bi-directional.

Thanks,

Pragati

[amitchandak · Accepted solution]

@Anonymous , Ideally there should a join between Sod Monthly and details (M-M) if it a details table then it should be 1-M.

Disable that and activate 1-M of Time and SOD detail.

See you can create a bridge table between SOD monthly and SOD details

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Or activate join using use relation as per need

[Anonymous]

Hello Amit,

@amitchandak 

another question regarding this topic. Now those working days are shown correctly after filtering by month. But when I filter by SOD (which are our employees) it filters me the right name for the total sales but not in the right matrix - it still shows all. Is there any simple soluation for that? Or is it possible to highlight the filtered person?

[Anonymous]

This is excactly what I needed! Thank you. I just began to work with Power BI and in Germany it is just kinda learning by doing. Thank you so much!