How to filter data from 2 tables for output in a 3rd one

[EleJim]

I have a modeling inquiry (or command question) in a 3 tables model.

T_Information has the column "PlanCode." The table filters the 2nd table T_Defective to get the list of defects in a model for a certain day.

T_Defective has the column SEQ (process sequence number ID) to get the origin of the defect.

And there's this 3rd table M_Process with the columns of process names, the SEQ number and the model's name code MCode.

After filtering I can get the following visualization from the 2nd table.

Now, if I change the X-axel to show me the process names from the 3rd table, the graph retrieves all process names of the model and counts all defects (see graph below).

How can I get the visualization right? To get number of defects by process name?

Thx in advance.

[ravsha85]

Hi @EleJim  In order to avoid many to many issues, you could try and create a surrogate key as explained in the below link and see if that suits the need

Can't create a relationship? Time for a surrogate key in Power BI! (youtube.com)