Count number of weeks in a year

[sagadgreat]

I have a problem that I beleive can only be solved by creating a table that counts the number of ISO weeks in a year.  I created a table (Year) that pulls in distinct year values for the past 3 years based on a separate (Dates) table.  I attempted to do a count of distinct weeks (Dates[ISOWeekNum]), but this was the result as there are truly a total of 53 weeks on the table.  I've tried several options to try to get it to be based on the Year column, but none are working.  Thoughts?:  

[mahoneypat · Accepted solution]

Try wrapping your DISTINCTCOUNT with CALCULATE( ), assuming you have a relationship between this table and your Dates table on the Year columns.  If not, you need to use TREATAS to pass the Year filter to the dates table.

Pat

[sagadgreat]

Haha, I never thought of connecting the years back to the original table.  Going to give it a shot.