Forum Discussion
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. ...
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
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
