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 trying to create a relationship between Tests linked to Requirements. I also have a working relationship between Systems and Requiremets.
Trouble is the Requirements can be tested by multiple Tests with some text so the cell is formated like shown.
Test data below.
If I don't slice by System everything is fine, showing total Requirements and Pass/Fail status for all Tests.
When I slice by a System I would like to see the test status for that system only but that does not work.
Solved! Go to Solution.
Hi @ams123,
I'm afraid you can't create a relationship like that. There are no same values. Though you can create a relationship, that won't work. Let's take your scenario as an example, there aren't any values in the Tests because there are no ids "200: foo" and "204: foo".
The solution could be as shown in the snapshot.
Best Regards,
Dale
Hi @ams123,
Did it help?
Best Regards,
Dale
After trying out you solution I better understand how that will fix my issue. Thanks,
Yup I appreciate the confirmation that I cannot do what I need to do in this case.
Hi @ams123,
I'm afraid you can't create a relationship like that. There are no same values. Though you can create a relationship, that won't work. Let's take your scenario as an example, there aren't any values in the Tests because there are no ids "200: foo" and "204: foo".
The solution could be as shown in the snapshot.
Best Regards,
Dale
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |