Forum Discussion
Calculated Column to show Percentage based on condition
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_
Hi,
These measures work
Total = COUNTROWS(Data)Done = CALCULATE([Total],Data[Status]="Done")Done (%) = DIVIDE([Done],[Total])Hope this helps.
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
2 Replies
- Ashish_Mathur
Super User
Hi,
These measures work
Total = COUNTROWS(Data)Done = CALCULATE([Total],Data[Status]="Done")Done (%) = DIVIDE([Done],[Total])Hope this helps.
- Ritaf1983
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