Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
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)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
122 | |
80 | |
47 | |
44 | |
35 |
User | Count |
---|---|
183 | |
84 | |
69 | |
48 | |
45 |