Calculated Column to Count based on Condition

[Anonymous]

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]

Thank you very much arul @Arul didn't expected for this quick solution

[Arul · Accepted solution]

@Anonymous ,

try this

Calculated Column = CALCULATE(
    COUNTA('Table'[Sprint]),
    ALLEXCEPT('Table','Table'[Sprint]))