% of Completed

[Anonymous]

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

[themistoklis]

@Anonymous 

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)
 

[Anonymous · Accepted solution]

[% 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.