Count with filtering on weeks

Hi Experts,

I wounder how can I write a DAX function that will do exactly the same what the Filtering visualization do!!

As per below screenshot, I created 6 tables each have spcific filtering based on weeks , now i need to create 1 table that will have the site ID counts from each of those 6 tables.