Forum Discussion

Frequent Visitor

3 years ago

Status Completion Tracker

Hello, Sorry if any of my questions come across as basic. It's been a long time since I have navigated Power BI and am currently working on a file that was built by someone else. The scenario is ...

Community Support

3 years ago

Sorry I didn't fully understand. Can you tell you what you expect the output to be based on the sample data you have provided so far? It can be shown in Excel.

Best Regards,

Community Support Team _Charlotte

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

brentleh
Frequent Visitor
3 years ago
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