Can Sumx not preset group by filter.

[sammy02hk]

Hi there,

I know that i can use Summarize for Article_code grouping. However are there any way I dont need to preset the grouping measure, as i do have lots of different grouping scenarios. Thank you very much.

LW Sales =

calculate(SUMx('Full 100013','Full 100013'[Sales]),

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

[wdx223_Daniel]

may the parameter of fields help you 

[sammy02hk]

Thank you for your reply. let me check.