Calculating Percentages base on text count

[Auski]

Hi all,

I had great success reaching out last time, I thought I would try again...

In PBI, I have a column called Three Point Check that contains either 'Required', 'Not Required' or blank.

Name	Date	Three Point Check
Andy	25/07/2023	Required
Andy	25/07/2023	Not Required
Mandy	25/07/2023	Required
Mandy	25/07/2023

The formula (once pivoted in excel) used to give an SLA is:

=SUM('Not Required'+'Required')/('Not Required'+'Required'+ blank)

Essentially, I'm hoping someone is clever enough to formulate a DAX to find out each agents SLA per day.

Hope this makes sense. Thank you for your time 🙂

[Ritaf1983 · Accepted solution]

Hi @Auski 

Try :

Sla = cALCULATE(COUNTROWS('Table'),'Table'[Three Point Check]="Not Required" || 'Table'[Three Point Check]="Required")/

 cALCULATE(COUNTROWS('Table'),'Table'[Three Point Check]="Not Required" || 'Table'[Three Point Check]="Required" ||  'Table'[Three Point Check]="")

Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Auski]

Amazing! Thank you so much @Ritaf1983! 

[Ritaf1983]

Glad to help 🙂