Forum Discussion

Auski's avatar
Auski
Icon for Advocate I rankAdvocate I
3 years ago
Solved

Calculating Percentages base on text count

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.

 

NameDateThree Point Check
Andy25/07/2023Required
Andy25/07/2023Not Required
Mandy25/07/2023Required
Mandy25/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 🙂

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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]="")
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    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]="")
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly