Summarize table with calculated progress percentage

[RoyalReduso]

Hi all!

Kind of stuck with the following. I have a table consisting out of 4 columns:

"Title of project", "Title of milestone","State","DueDate"

Example:

Project A|Introduction|Completed|11/30/2023
Project A|FollowUp|Active|01/31/2024

Project B|Introduction|Active|02/28/2024

I am trying to create a summarition table that would give me the following:

"Title of project","Time","Expected %","Actual %"

Which would result in:

Project A|2023|50%|50%

Project A|2024|100%|50%

Project B|2024|100%|0%

However, when I create a summarized table how do I get a calculation ont he expected table instead of the following:

Project A|2023|50%|50%

Project A|2023|50%|50%

Project B|2024|100%|0%

I used the following formula for this:

Combined =

(

    SUMMARIZE (

        ProjectProgress,

        ProjectProgress[DueDate].[Year],

        ProjectProgress[TitleofProject],

        "Expected", ( COUNTROWS ( ProjectProgress ) ) / CALCULATE( COUNTROWS ( ( ProjectProgress ) ), ALLEXCEPT( ( ProjectProgress ),ProjectProgress[TitleofProject] )) ,

        "Progress",

            (

                COUNTROWS ( FILTER ( ProjectProgress, ProjectProgress[State] = "Completed" ) )

            )

                / CALCULATE ( COUNTROWS ( ProjectProgress ), ALLEXCEPT( ( ProjectProgress ),ProjectProgress[TitleofProject] )

    )

))

Thank you for your help!

[lbendlin]

what is the source for the expected percentage?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...