summarize table with filters

Question

Hi,&nbsp;I'm trying to create a summarized table with multiple filters and sum of measures but I'm getting different error.&nbsp; I tried to combine CALCULATETABLE, SUMMARIZE and filter functions but could not seem to work.&nbsp; My formula here is without FILTER function.&nbsp; Can you please help me what should be the correct formula?&nbsp;&nbsp;&nbsp;Summary =CALCULATETABLE(SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Table1',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Table1'[ProductID],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Table1'[Year],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Table1'[Month]&nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Sales",SUM('Table1'[Sales]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Expenses",SUM('Table1'[Expenses]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Products Sold",SUM('Table1'[Numbers Sold]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Table1'[Region] in {"Americas","Europe"},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Table1'[Channel]="Online"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

amitchandak · Accepted Answer

summer18 , Try Like
&nbsp;
SUMMARIZE(Filter( 'Table1','Table1'[Region] in {"Americas","Europe"} &amp;&amp; 'Table1'[Channel]="Online" )'Table1'[ProductID],'Table1'[Year],'Table1'[Month] ,"Sales",SUM('Table1'[Sales]),"Expenses",SUM('Table1'[Expenses]),"Products Sold",SUM('Table1'[Numbers Sold]) )

Forum Discussion

summarize table with filters

2 Replies

Related content

Merge Summarize Table

Parameter table dimensions - summarize

filtering summarized table

Filtered table

Summarize Table and Filter by Date