Calculated Column to show Percentage based on condition

[Anonymous]

Dear All,

I  am using below table to get percantage of the sprint 

Sno	Issues	Status	Sprint
1	768	Done	Sprint6
2	888	Done	Sprint6
3	666	QA in Progress	Sprint6
4	999	Deployed in Prod	Sprint6
5	567	Done	Sprint5
6	900	Done	Sprint5
7	100	In-Progress	Sprint5

would like to have a one calucalted column for the below table that tells about the perceantge of number of issues done in the each sprint  such as below

if (Table[Sprint]="Sprint6") than (total issues where status is done &  where sprint=6 )/( total issues where sprint=6) else

if (Table[Sprint]="Sprint5") than (total issues where status is done &  where sprint=5 )/( total issues where sprint=5) else
if (Table[Sprint]="Sprint4") than (total issues where status is done &  where sprint=5 )/( total issues where sprint=4) else

Can any one please help me how can I make it.

Regards,
SAM_

[Ashish_Mathur · Accepted solution]

Hi,

These measures work

Total = COUNTROWS(Data)

Done = CALCULATE([Total],Data[Status]="Done")

Done (%) = DIVIDE([Done],[Total])

Hope this helps.

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
If I understood you correctly and the goal is to show the percentage of "Done" by sprint you can use the measures :
1.

Count_done = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Sprint]),'Table'[Status]="Done")

2.

Percent_of_done = if(max('Table'[Status])="Done", divide([Count_done],CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Sprint]))),"")

Result:

if it is something else plese

Pbix is attached

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

[Ashish_Mathur · Accepted solution]

Hi,

These measures work

Total = COUNTROWS(Data)

Done = CALCULATE([Total],Data[Status]="Done")

Done (%) = DIVIDE([Done],[Total])

Hope this helps.