Forum Discussion
Creating a measure for different hierarchies
Included a sample table here.
| ID | Date | Facility Type | Site | Department | Team | Attribute | Levels |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | Team Dynamic | 2 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | Leadership | 2 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | SKAP | 2 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | Multiskill | 2 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | Safety Culture | 2 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | Quality | 3 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | Problem Solving | 3 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | VPO Champion | 2 |
| 1 | 1/25/2023 | Brewery | JKV | PKG | L35 | ATO | 4 |
| 2 | 1/26/2023 | Brewery | JKV | PKG | L95 | SKAP | 2 |
| 2 | 1/26/2023 | Brewery | JKV | PKG | L95 | Multiskill | 1 |
| 2 | 1/26/2023 | Brewery | JKV | PKG | L95 | Safety Culture | 3 |
| 2 | 1/26/2023 | Brewery | JKV | PKG | L95 | Quality | 2 |
| 2 | 1/26/2023 | Brewery | JKV | PKG | L95 | Problem Solving | 2 |
The results I'm expecting are as follows -
When Department slicer is applied,
Phase Progress should be as follows -
Phase 1 - 9/9 = 100% (because both teams are at least at a 1 or above
Phase 2 - 8/9 = 89.8% (because even though Multiskill is 2 for L35, it is 1 for L95 and at the higher view, they would consider their teams are at 1 since not all are at 1. So basically when multiple teams are involved, consider the least value for that attribute. Also because ATO is at 4, which means they completed level 2 already)
Phase 3 - 1/9 = 11.1% (Because ATO is at 4 and they would have completed 3 to go to 4. But no other attributes are in that level for both the teams)
Phase 4 - 1/9 = 11.1% (Because of ATO)
I hope this clears it up a little bit more. This is the same logic that will be applied as we go up the hierarchy.