I am trying to create a summary table so that many to one relationship can be buit with another table. I want to filter out records for a specific month only. For this, i have written the following command: MFH_Summary = SUMMARIZECOLUMNS( MFH_MailQuantities[MonthYear],MFH_MailQuantities[Franchise],MFH_MailQuantities[Store],"Summ_Mail_Qty",sum(MFH_MailQuantities[MailQty]), FILTER(MFH_MailQuantities, MFH_MailQuantities[MonthYear] = [Selected_Month]) )
In the above expression, selected_month is measure for fetching slicer selection. Selected_Month = SELECTEDVALUE(MFH_MailQuantities[MonthYear])
Howvever, i am getting an error - Function SUMMARIZECOLUMNS expects a column name as argument number 6.
I am unable to resolve the error. Any help will be greatly appreciated.