Forum Discussion
Calculated Column to Count based on Condition
Dear All,
I am having the below table and I had created and want to have only one Calculated Column tha tells about total number of Rows for Sptin6 and total number rows in sprint5 .
| 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 |
Thanks & Regards,
SAM_
Anonymous ,
try this
Calculated Column = CALCULATE( COUNTA('Table'[Sprint]), ALLEXCEPT('Table','Table'[Sprint]))
