Status Completion Tracker

Thank you for taking the time to respond. I will do better to explain and I have attached pictures  to hopefully help better.

This is the Raw data that we pull from our sharepoint into Power BI

I can set up a run to make all "null" fields to blank as seen on this image. But this is where I am pulling the data from.

In Excel I use a Pivot table then build a reference table:

I am looking for a way I can build either a measure or something to show me the % complete in Power BI like I have in excel. 

This is the formula I am using in Excel: 

The issue I run into is that all the data (Blocked/Failed etc) comes from one specific column that has those labels in it and I have pulling the "Count Of" to get my numbers. I am able to create the matrix in Power BI to get the data to represent how I want in a table ( see second image in first post image), however I am unable to create the % Complete tab that I have on my excel sheet as seen here:

This is what I am able to get in Power BI (ignore the difference in overal numbers as these were two different test) but I can not for the life of me figure out how to accomplish in Power BI what I am able to do in Excel. 

Thank you again for your help

I have included