count rows when a measure is >=0.85

guanel1 — Wed, 15 Sep 2021 22:53:53 GMT

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%?

Re: count rows when a measure is >=0.85

wdx223_Daniel — Thu, 16 Sep 2021 01:23:22 GMT

# of BU Met Completion =CALCULATE([# of OU],FILTER(VALUES(Table1[Business Unit]),[% of Completed on Time]>=0.80)))

Re: count rows when a measure is >=0.85

guanel1 — Thu, 16 Sep 2021 15:39:46 GMT

perfect. 1000x thanks!

topic Re: count rows when a measure is >=0.85 in DAX Commands and Tips

count rows when a measure is >=0.85

Re: count rows when a measure is >=0.85

Re: count rows when a measure is >=0.85