Percent of words in a column

[racheljeska]

Hi All! 

I have a column named Status with the values: Completed, Overdue, and Comining Due. 

I want to create a % Completed by doing #Completed/ (#Completed + #Overdue + #Coming Due) 

How do I type in this equation? 

[bevicor · Accepted solution]

You could probably create this measure:
PercentComplete = Calculate(Count(yourTableName[Status]),yourTableName[Status]="Completed")/Count(yourTableName[Status])

[racheljeska]

Wonderful!! Thank you!