Team coverage calculations

mwebergo2 , Create a new column to identify if a task has a single point of failure. This column will count the number of team members with a proficiency of 4 or 5 for each task

DAX
SinglePointOfFailure =
CALCULATE(
COUNTROWS('YourTable'),
FILTER('YourTable', 'YourTable'[Proficiency] >= 4)
)

Create a measure to calculate the percentage of tasks with a single point of failure:

DAX
PercentageSinglePointOfFailure =
DIVIDE(
COUNTROWS(
FILTER(
SUMMARIZE('YourTable', 'YourTable'[Task], "CountHighProficiency", [SinglePointOfFailure]),
[CountHighProficiency] = 1
)
),
COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[Task])),
0
)

Create a new column to identify if a task has a gap. This column will count the number of team members with a proficiency of 3 or higher for each task.

DAX
Gap =
CALCULATE(
COUNTROWS('YourTable'),
FILTER('YourTable', 'YourTable'[Proficiency] >= 3)
)

DAX
PercentageGap =
DIVIDE(
COUNTROWS(
FILTER(
SUMMARIZE('YourTable', 'YourTable'[Task], "CountProficiency", [Gap]),
[CountProficiency] = 0
)
),
COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[Task])),
0
)

Use the measures PercentageSinglePointOfFailure and PercentageGap to create visuals in your Power BI dashboard to display these metrics.