Solution for COUNTIFS

Please give this a try:

Column D =
CALCULATE (
    COUNTROWS ( 'TableName' ),
    ALLEXCEPT (
        'TableName',
        'TableName'[Team Name],
        'TableName'[Week #],
        'TableName'[Year]
    )
)

Hi ShrikantKhanna,

You can use EARLIER function when you create calculated column. I used FILTER(Table5,Table5[Team Name]=EARLIER(Table5[Team Name])), which mean it will return the subtable with same Team name. Filter is compared to the criteria. Then I add multiple filters, so the formula will count [Team Name] where satisfy Filter1, Filter2, Filter3 and so on. 

Result = CALCULATE(COUNTA(Table5[Team Name]),FILTER(Table5,Table5[Team Name]=EARLIER(Table5[Team Name])),FILTER(Table5,Table5[Week#]=EARLIER(Table5[Week#])),FILTER(Table5,Table5[Year]=EARLIER(Table5[Year])))

Please review expected result in the following screenshot.

If you have other issues, please feel free to ask.

Best Regards,
Angelia