Thanks for your reply! This is a bit messy. I made a little more headway with my data, and hopefully this post will clarify the situation.
From the output table below,
In June, AlPa-W performed 2 Drills (TableA), but was expected to do 3 (TableB), causing a completion rate of 66%.
/ usingRAW Completion =DIVIDE(COUNT('TempData'[Drill Type]),DISTINCTCOUNT('Drill_by_Month'[ExpectedDrills]))
No problem so far, however, that location has no Overnight Staff (identified in TableA field as Yes/No)
Since one of the drills is expected overnight, for that location and all that are "No", I need to reduce the expected number to 2 to give me a completion rate for those sites of 100%
Count of Drill Type is a count
Count of Expected is a distinct count
| Month Name | June | | July | |
| Idv-Prog | Count of Drill Type | Count of ExpectedDrills | Count of Drill Type | Count of ExpectedDrills | Count of Drill Type | Count of ExpectedDrills | Count of Drill Type | Count of ExpectedDrills |
| AlBo-L | 4 | 3 | 1 | 3 | 4 | 3 | 9 | 3 |
| AlLu-L | 3 | 3 | 2 | 3 | 4 | 3 | 9 | 3 |
| AlPa-W | 2 | 3 | 4 | 3 | 4 | 3 | 10 | 3 |
| AmBu-L | 4 | 3 | 2 | 3 | 5 | 3 | 11 | 3 |
| AnMo-W | 1 | 3 | 3 | 3 | 4 | 3 | 8 | 3 |
| AnWa-R | 1 | 3 | 3 | 3 | 4 | 3 | 8 | 3 |
| AnWe-F | 1 | 3 | 1 | 3 | 4 | 3 | 6 | 3 |
| AnWh-V | 2 | 3 | 3 | 3 | 4 | 3 | 9 | 3 |
| AnZa-N | | | 2 | 3 | 4 | 3 | 6 | 3 |
| ApWo-W | 1 | 3 | 3 | 3 | 5 | 3 | 9 | 3 |
| ArBa-A | | | | | 4 | 3 | 4 | 3 |
| AsTu-W | 1 | 3 | 3 | 3 | 4 | 3 | 8 | 3 |
