Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a matrix, where I want to show blank values in the top level, I have applied HASONEVALUE as below but some cells are showing values not blank. Most seem to be where there is only 1 value lower down.
The data only has a row if there is a planned loading on an activity, and does not have a row with a blank on it.
Sample data
RESOURCE_DESCRIPTION | PLANNED_HOURS | PROJECT_ID | FY & Week | WORKING HOURS PER WEEK |
1000325 | 1 | 123 | 2024-14 | 7.5 |
1000325 | 2 | 123 | 2024-14 | 7.5 |
1000325 | 5 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 123 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 6 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 8 | 987 | 2024-14 | 7.5 |
1000325 | 5 | 123 | 2024-14 | 7.5 |
1000325 | 5 | 123 | 2024-14 | 7.5 |
1000325 | 5 | 123 | 2024-14 | 7.5 |
1000325 | 8 | 987 | 2024-14 | 7.5 |
1000325 | 0.05 | 123 | 2024-14 | 7.5 |
1000325 | 0.05 | 123 | 2024-14 | 7.5 |
1000325 | 0.05 | 123 | 2024-14 | 7.5 |
1000325 | 0.05 | 123 | 2024-14 | 7.5 |
1000325 | 0.05 | 987 | 2024-14 | 7.5 |
1000325 | 9 | 123 | 2024-14 | 7.5 |
Please show the expected outcome based on the sample data you provided.
I would like this please, blanks on all top level "resource group"
User | Count |
---|---|
94 | |
78 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |