cancel
Showing results for
Did you mean:
Helper V

## % of Completed

Hi Team,

I want to select the % of completed out off status.

User needs Slicers as Project column.

If user selects A from Slicer = total completed / Total count.

 Project Sub Project Planned Start Date Planned Closed Date Actual Start Date Actual Closed Date Status A AA 1/12/2020 1/12/2021 1/2/2021 Completed A AB 1/1/2020 1/6/2020 1/4/2020 1/10/2020 Inprogress A AC 1/6/2021 1/12/2021 Completed B BA 1/5/2021 1/12/2021 Delayed B BB 1/4/2020 1/6/2020 1/6/2020 1/8/2021 Completed B BC 1/3/2021 1/5/2021 1/4/2021 1/6/2021 Inprogress B BD 1/3/2021 1/5/2021 1/4/2021 1/6/2021 Inprogress
1 ACCEPTED SOLUTION
Solution Sage

``````[% Completed] =
DIVIDE(
CALCULATE(
COUNTROWS( T ),
KEEPFILTERS( T[Status] = "completed" )
),
COUNTROWS( T )
)``````

Warning:

Using one-table models can lead to wrong numbers being calculated even by good formulas. Please always use star schemas.

2 REPLIES 2
Super User II

Try the following:

Measure  =

var completed = CALCULATE( COUNTROWS('Table'), Table[Status] = "Completed" )

var total =CALCULATE( COUNTROWS('Table'), ALLEXCEPT(Table, Table[Project] )

Return

DIVIDE(completed , total)

Solution Sage

``````[% Completed] =
DIVIDE(
CALCULATE(
COUNTROWS( T ),
KEEPFILTERS( T[Status] = "completed" )
),
COUNTROWS( T )
)``````

Warning:

Using one-table models can lead to wrong numbers being calculated even by good formulas. Please always use star schemas.

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.