Percentage of internal applicants

[alexcatala]

Hi, 

I am currently working in a formula to calculate the percentage of only the internal applicants who have been hired(excluding the blanks). Filtering by store and excluding the SA (Retail position).

Here it is a sample of data: the main database is called Recruitment Tracker and these are the fields inside:

Store	Retail position	Hired Date	Internal External	Candidate Name
709	SA		External	Mike
709	SA	01/02/2020	Internal	Sara
709	SUP	03/01/2020	External	Anne
709	SUP	02/10/2020	Internal	Kevin

Thanks for the help

[amitchandak · Accepted solution]

@alexcatala , Try a measure like

divide(calculate(countrows(table), filter(table, not(isblank(Table[hire date])) && Table[Internal External] = " Internal External")),calculate(countrows(table), filter(table, not(isblank(Table[hire date])))))