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.
Hello,
I'm trying to have a consolidate results but I have difficulties to do it.
My database is the following:
Sub entity Code Coverage
Sub entity 1 01 Covered
Sub entity 2 01 Covered
Sub entity 3 01 Covered
Sub entity 1 02 Partially
Sub entity 2 02 Covered
Sub entity 3 02 Covered
Sub entity 1 03 Not covered
Sub entity 2 03 Not covered
Sub entity 3 03 Not covered
When I build a chart per sub entity representing the number of codes per coverage, I have no problem. However, if I select all the sub entities, I would like to have a consolidate view taking into account the following rules : if all are covered then it is covered, if all are not covered, then it is not covered, otherwise, it is partially covered.
Sub entity Code Coverage
Entity 01 Covered
Entity 02 Partially
Entity 03 Not covered
I'm not sure about what I need to do (creating a column or a measure).
Could you help with this issue?
Jérémie
Solved! Go to Solution.
I think this measure should work:
be aware I used "nc" for "not covered" and "p" for "partially" so you have to correct that
I think this measure should work:
be aware I used "nc" for "not covered" and "p" for "partially" so you have to correct that
Great! It works. Thank you
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |