Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
EleJim
Regular Visitor

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

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.

EleJim_3-1722141458447.png

 

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

EleJim_1-1722140673837.png

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).

EleJim_2-1722140862133.png

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

Thx in advance.

1 REPLY 1
ravsha85
Frequent Visitor

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)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors