I have a list of Business Units (BU) with Teams. Each team has deliverables due. I have calculated the % of deliverables completed on time for each BU. I created the following measures:
# of OU = DISTINCTCOUNT(Table1[BU]) --> needs to be distinct because there are multiple instances of the BU name as there are multiple Deliverables for each team within the BU.
# of Deliverables = COUNTA(Table1[Deliverable ID])
# of Completed On Time = CALCULATE(COUNTA(Table1[STATUS]),Table1[STATUS]="COMPLETED ON TIME")
% Completed on Time = DIVIDE([# of Completed On Time],[# of Deliverables])
My resulting visual (table) looks like this:
| Business Unit | # of Teams | # of Deliverables | # of Completed on Time | % of Completed on Time |
| A | 6 | 10 | 8 | 80% |
| B | 10 | 15 | 10 | 67% |
| C | 4 | 5 | 5 | 100% |
| D | 12 | 18 | 16 | 89% |
I want to create a measure that will count the BU's only when the total % of Completed on time is >=0.80 (or 80%)
And in doing so, I want the answer to be 3. (3 BU's met the above criteria)
I tried to create the following measure with nesting measures:
# of BU Met Completion = CALCULATE([# of OU],[% of Completed on Time]>=0.80)
But i get an error. A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
I was assuming that it would show 4-1(one BU with less than 80%) = 3
Does anyone know how I can get a measure to count the # of BUs when the total % of completed on Time is >=80%?
