Forum Discussion
Solved
summarize table with filters
Hi, I'm trying to create a summarized table with multiple filters and sum of measures but I'm getting different error. I tried to combine CALCULATETABLE, SUMMARIZE and filter functions but could...
summer18 , Try Like
SUMMARIZE(Filter(
'Table1','Table1'[Region] in {"Americas","Europe"} &&
'Table1'[Channel]="Online" )
'Table1'[ProductID],
'Table1'[Year],
'Table1'[Month] ,
"Sales",SUM('Table1'[Sales]),
"Expenses",SUM('Table1'[Expenses]),
"Products Sold",SUM('Table1'[Numbers Sold]) )
Thank you very much amitchandak , it works! I've been struggling on this for hours.