Help to show the completion status

Hi SDVN  - Create a new calculated column in Power BI that determines the current stage of each project.

Project Stage =
VAR Stages = {"Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"}
VAR CompletedStages =
FILTER(
Stages,
SWITCH(
TRUE(),
SELECTEDVALUE('Projects'[Stage 5]) = "Completed", 5,
SELECTEDVALUE('Projects'[Stage 4]) = "Completed", 4,
SELECTEDVALUE('Projects'[Stage 3]) = "Completed", 3,
SELECTEDVALUE('Projects'[Stage 2]) = "Completed", 2,
SELECTEDVALUE('Projects'[Stage 1]) = "Completed", 1,
0
) = VALUE(RIGHT([Value],1))
)
RETURN
MAXX(CompletedStages, VALUE(RIGHT([Value],1)) + 1)

you can also count the number of projects by using measure below:

Projects per Stage =
COUNTROWS(
FILTER('Projects', 'Projects'[Project Stage] = SELECTEDVALUE('Stages'[Stage Number]))
)

Hope this helps.