Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am reporting out of VSTS for a project. I have a table of defects and a table of Test cases joined to the work items links table. I am certain that these values are correct but are the totals. Seems something is wrong with the join as the total is being elicted in every cell.
Hi jamespusateri ,
"I am certain that these values are correct but are the totals. Seems something is wrong with the join as the total is being elicted in every cell."
<--- What's the relationship between three tables and matrix chart? Could you please more details about your matrix chart and expected result?
Regards,
Jimmy Tao
single, one to many, defects joined to Targetid from workitemid and TC's joined to sourceid from workitemid. Yes its a relationship issue. When I change to Both directionally the values are parsed correctly but results are filtered out.
Hi jamespusateri,
Which columns in the three tables are your chart based on? Are you trying to use 'Defects' to filter table 'Test Cases'?
Regards,
Jimmy Tao
Found that my initial join was correct and the totals were inline with expected results.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |