Percentage of Completed Projects

[Alta88]

How would I create a measure to show how many projects (as a percentage) have been completed within that latest calendar month?

[v-heq-msft]

Hi @Alta88 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Percentage = 
VAR _coutRows = COUNT('Table'[Project ID])
VAR _rows = 
CALCULATE(
    COUNT('Table'[Project ID]),
    FILTER(
        'Table',
        'Table'[Status] = "Completed" && 'Table'[Comopleted Date] >= DATE(YEAR(TODAY()),MONTH(TODAY()),1) && 'Table'[Comopleted Date] <= EOMONTH(TODAY(),0)
    )
)
RETURN
_rows/_coutRows

Final output

Best regards,
Albert He

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

[Alta88]

Cool! Looks like it worked! Thanks for your help!

[Alta88 · Accepted solution]

Yes, here's the data again: 

[PhilipTreacy]

@Alta88 

Thanks for the data showing completed projects.  That info wasn't in the first image you shared.

Just FYI, it's always good practice to provide data for us to help you, not images.  We have to enter all that data into PBI before we can start on a solution.  You'll get a better response from people if you provide data as a file or at least a table in the forum.

You also haven't given an example of the desired result.  You say you want 'a measure to show how many projects (as a percentage) have been completed within that latest calendar month' :

• Is that a percentage compared to all projects?
• A percentage of projects completed compared to their due date 
• A percentage of projects compared to all projects except those that have a status of 'Submitted', 'Blocked' or 'Awaiting Approval'?
• Something else?

Regards

Phil

[PhilipTreacy]

Hi @Alta88 

In your data there isn't anywhere that says when a project is completed.  Need this to do any kind of calculations.

Regards

Phil