Calculated Column to show Percentage based on condition

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