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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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