How to calculate percentage after filtering multiple columns?

[DL]

Hi,

I am trying to write a DAX formula to calculate the percentage of "Responsible Team" that have days completed "35 days or less " and have "ended in period".

I am applying filters to the 2 columns:

Ended in Period    to "Ended in Period" and

Days Completed     to "35 days or less"

 In this instance  the percentage would be 50% (6/12)       

Responsible Team    Ended in Period    Days completed

Team 1	Ended in Period	35 days or less
Team 1		35 days or less
Team 1	Ended in Period	35 days or less
Team 1	Ended in Period	Over 35 Days
Team 1	Ended in Period	Over 35 Days
Team 1	Ended in Period	Over 35 Days
Team 1	Ended in Period	Over 35 Days
Team 1	Ended in Period	35 days or less
Team 1	Ended in Period	35 days or less
Team 1	Ended in Period	35 days or less
Team 1	Ended in Period	Over 35 Days
Team 1	Ended in Period	Over 35 Days
Team 1	Ended in Period	35 days or less

Kind regards, DL

[Anonymous · Accepted solution]

So you only want to calculate the values if they are ended in period, correct? If that is a true assumption then this should work. My table name is Percentage2 in this example:

Percentage =
CALCULATE(
COUNTA(Percentage2[Responsible Team])
,Percentage2[Ended in Period] = "Ended in Period"
,Percentage2[Days Completed] = "35 Days or less"
)
/
CALCULATE(
COUNTA(Percentage2[Responsible Team])
,Percentage2[Ended in Period] = "Ended in Period"
)

[DL]

That's worked - thank you so much!