topic Sumx not working with summarize in DAX Commands and Tips

Sumx not working with summarize

sammy02hk — Wed, 15 Feb 2023 02:50:58 GMT

Hi there,

I try to use sumx with summarize to group the article_code. However its not work as well. Which is work in my other bi report.

I would like to sum Sales by ArticleCode within the Period StartDate2 to +6. Thank you very much....

LW Sales 1 =

SUMX(
SUMMARIZE(

'Full 100013','Full 100013'[Article_Code],'Full 100013'[Billing_Date]),

Var StartDate = LOOKUPVALUE(DATA_LIST_CUR_DateMatch[LW],DATA_LIST_CUR_DateMatch[Date],

SELECTEDVALUE(DATA_LIST_CUR_DateMatch[WkMonday]))

Var StartDate2 = DATE(LEFT(StartDate,4),MID(StartDate,6,2),RIGHT(StartDate,2))

return

calculate(

SUMX('Full 100013','Full 100013'[Sales]),

filter(all('Full 100013'),'Full 100013'[Billing_Date]>= StartDate2 &&

'Full 100013'[Billing_Date]<= StartDate2 +6 )))

Thank you very much....

Re: Sumx not working with summarize

sammy02hk — Tue, 14 Feb 2023 09:31:23 GMT

I have try different way to write the syntax but it is not working at all. The no is correct, just cant group by with summarize.

Thank you for your help....

Re: Sumx not working with summarize

Anonymous — Thu, 16 Feb 2023 06:14:37 GMT

Hi sammy02hk

Maybe you can try the following code

LW Sales 1 = Var StartDate = LOOKUPVALUE(DATA_LIST_CUR_DateMatch[LW],DATA_LIST_CUR_DateMatch[Date], SELECTEDVALUE(DATA_LIST_CUR_DateMatch[WkMonday])) Var StartDate2 = DATE(LEFT(StartDate,4),MID(StartDate,6,2),RIGHT(StartDate,2)) return SUMX(filter(all('Full 100013'),'Full 100013'[Article_Code]=Max('Full 100013'[Article_Code])&&'Full 100013'[Billing_Date]>= StartDate2 && 'Full 100013'[Billing_Date]<= StartDate2 +6 ),[Sales])

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Sumx not working with summarize

sammy02hk — Mon, 20 Feb 2023 06:29:11 GMT

Hi Yolo,

Thank you for your help ...

Sammy