Passing filter in a weekly calculation measure

[HusseinKhalil]

Good day

i am trying to create measure for the good sold in the current week using the below formula

Weekly_Sold = CALCULATE(COUNT(table[GoodSold]),FILTER(table,WEEKNUM(TODAY(),1)=WEEKNUM(MAX(table[SalesDate]),1)))

everytime it gives the total count of sold goods across the column, passing any filters

appreciate your help

[v-eachen-msft]

Hi @HusseinKhalil ,

You could refer to the following measure.

Measure =
CALCULATE (
    COUNT ( 'Table'[GoodSold] ),
    FILTER (
        'Table',
        WEEKNUM ( TODAY(), 1 )
            = WEEKNUM (
                CALCULATE (
                    MAX ( 'Table'[SalesDate] ),
                    ALLEXCEPT ( 'Table', 'Table'[GoodSold] )
                ),
                1
            )
    )
)

[amitchandak]

@HusseinKhalil , For Week, refer my blog

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

[HusseinKhalil]

@amitchandakthanks a million for the rich response, it would help me a lot in the future cases. i was just after the logic issue of my formula.

@v-eachen-msftthanks v, i tried your formula but it returned with the events of below dates

Date	WeekNUM
6/9/2020	24
6/10/2020	24
6/11/2020	24
6/14/2020	25
6/15/2020	25
6/16/2020	25
6/17/2020	25
6/18/2020	25
6/20/2020	25
6/21/2020	26
6/22/2020	26

[v-eachen-msft]

Hi @HusseinKhalil ,

Maybe I misunderstood your needs. You could share your expected output with files or screenshots here.

[HusseinKhalil]

hello @v-eachen-msft  please have a look below, i need to count goods solds based on this week and previous week for example, today the 23rd June in my region, i want to find W26 & W25 sales.

thanks 

Good Sold ID	Date
244128	4/7/2020
244133	4/16/2020
244140	4/16/2020
244143	4/16/2020
244146	4/16/2020
244149	6/14/2020
244153	4/9/2020
244155	4/14/2020
244158	4/16/2020
244159	6/14/2020
244179	4/16/2020
244190	4/15/2020
244211	4/18/2020
244214	4/14/2020
244216	4/14/2020
244229	6/4/2020
244234	5/7/2020
244240	6/10/2020
244241	6/22/2020
244242	4/18/2020
244251	4/29/2020
244255	4/2/2020
244258	4/9/2020
244271	4/15/2020
244272	4/18/2020
244273	4/18/2020
244280	6/18/2020
244281	4/15/2020
244321	4/18/2020
244326	4/15/2020
244331	4/18/2020
244336	4/18/2020
244341	4/18/2020
244355	6/4/2020
244362	4/7/2020
244393	6/22/2020
244406	5/7/2020
244420	6/15/2020
244424	4/18/2020
244425	4/18/2020
244430	4/18/2020
244435	4/18/2020
244455	5/5/2020
244467	4/18/2020
244473	6/18/2020
244476	4/13/2020
244477	4/18/2020
244481	4/5/2020
244482	4/18/2020
244485	5/31/2020
244492	4/18/2020
244504	6/15/2020
244514	5/31/2020
244519	4/18/2020
244527	4/29/2020
244569	4/18/2020
244571	5/10/2020
244581	4/18/2020
244587	6/18/2020
244588	4/27/2020
244594	4/9/2020
244600	5/20/2020
244626	5/21/2020
244628	6/7/2020
244639	5/5/2020
244654	5/31/2020
244670	6/18/2020
244673	6/8/2020
244698	6/16/2020
244816	6/15/2020
244822	4/18/2020
244851	6/21/2020
244853	5/31/2020
244889	6/21/2020
244902	4/13/2020
244914	6/21/2020
244916	4/1/2020
244926	5/12/2020
244937	6/21/2020
244951	6/18/2020
244953	4/18/2020
244995	4/18/2020
245026	5/5/2020
245031	6/4/2020
245033	4/18/2020
245063	5/19/2020
245078	4/18/2020
245147	6/21/2020
245159	4/18/2020
245191	4/18/2020
245225	4/18/2020
245747	4/9/2020
245812	4/9/2020
245819	6/17/2020
245828	4/1/2020
245846	5/10/2020
245850	6/16/2020
245853	4/20/2020
245874	4/25/2020
245895	4/8/2020
245915	6/2/2020
245938	5/11/2020
245981	4/21/2020
245993	5/16/2020
246139	4/29/2020
294221	5/21/2020
296089	4/18/2020
296092	4/14/2020
296099	6/14/2020
296103	4/14/2020
296136	5/20/2020
296162	4/14/2020
296362	6/4/2020
296392	6/9/2020
297101	4/29/2020
297121	4/1/2020
297131	4/25/2020
298877	4/18/2020
298909	4/18/2020
298916	4/18/2020
298937	4/18/2020
298938	6/8/2020
298944	5/11/2020
298950	5/10/2020
298958	5/5/2020
298959	6/4/2020
298961	4/18/2020
298965	6/15/2020
299183	4/1/2020
302243	4/18/2020
302247	5/10/2020
302250	4/18/2020
302252	4/18/2020
302255	5/17/2020
302259	6/14/2020
302265	4/18/2020
302293	4/7/2020
302298	4/14/2020
302301	4/9/2020
302305	4/2/2020
302307	4/18/2020
302323	4/15/2020
302340	4/18/2020
302344	5/3/2020
302351	4/7/2020
302353	4/18/2020
302370	4/18/2020
302379	5/10/2020
302386	4/18/2020
302390	5/3/2020
302393	4/18/2020
302395	4/18/2020
302407	4/18/2020
302408	6/8/2020
302410	6/8/2020
302430	6/15/2020
302442	4/18/2020
302447	5/10/2020
302455	5/19/2020
302465	4/18/2020
302468	4/18/2020
302471	4/18/2020
302475	4/9/2020
302484	6/18/2020
302493	4/2/2020
302510	5/5/2020
302520	5/20/2020
302524	4/18/2020
302529	5/10/2020
302540	4/29/2020
302544	5/10/2020
302545	4/18/2020
302553	4/18/2020
302562	4/29/2020
302569	5/31/2020
302586	5/10/2020
302594	5/3/2020
302619	5/5/2020
302622	6/11/2020
302650	4/29/2020
302652	4/18/2020
302671	4/18/2020
302672	4/18/2020
302676	5/10/2020
302686	5/10/2020
302696	4/18/2020
302705	4/18/2020
302720	6/21/2020
302721	6/22/2020
302735	5/20/2020
302736	4/18/2020
302745	5/17/2020
302761	5/3/2020
302787	5/5/2020
302790	5/31/2020
302791	6/9/2020
302799	4/18/2020
302815	4/5/2020
302817	4/5/2020
302839	4/18/2020
302846	4/18/2020
302847	4/18/2020
302889	4/18/2020
302938	4/5/2020
302941	6/22/2020
302954	4/18/2020
302967	6/18/2020
303011	5/5/2020
303060	4/18/2020
303061	6/21/2020
303096	4/18/2020
303097	4/18/2020
303161	4/18/2020
303215	6/10/2020
304094	4/22/2020
305231	5/21/2020
305300	5/31/2020
306168	5/30/2020
306173	6/20/2020
306180	5/11/2020
306182	4/18/2020
308711	4/18/2020
309025	5/17/2020
309029	6/2/2020
309522	4/21/2020
309523	4/18/2020
309524	4/5/2020
309556	5/19/2020
309557	5/20/2020
309558	5/13/2020
309726	4/18/2020
309727	5/12/2020
309728	4/2/2020
316390	6/4/2020
316391	6/4/2020
316392	5/31/2020
316393	6/4/2020
316511	6/10/2020
316670	6/11/2020
316671	6/14/2020
244291	6/22/2020
244611	4/18/2020
245996	4/29/2020
296145	6/3/2020
297119	5/13/2020
302309	4/13/2020
302478	6/15/2020
302479	6/16/2020
302716	6/10/2020
302731	5/21/2020
306178	6/18/2020
316097	6/11/2020
316098	6/15/2020