Count with filtering on weeks

[ahmedelgibaly]

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.

[v-chuncz-msft · Accepted solution]

@ahmedelgibaly,

You may take a look at https://www.sqlbi.com/articles/filter-arguments-in-calculate/.