cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Error in SUMMARIZECOLUMNS

Hi,

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.

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Sage
Solution Sage

@Velocity 

 

Try using Summarize function

filterSummarize(Table, feild 1, field2, Month,"Colum head",required values,"Columhead2",required Value),month="Specific month you want)

Hope this will be the solution for your problem statement and if you find this as solution please mark this as solution and share your Kudoes.

Vijay Perepa

View solution in original post

4 REPLIES 4
Solution Sage
Solution Sage

@Velocity 

 

Try using Summarize function

filterSummarize(Table, feild 1, field2, Month,"Colum head",required values,"Columhead2",required Value),month="Specific month you want)

Hope this will be the solution for your problem statement and if you find this as solution please mark this as solution and share your Kudoes.

Vijay Perepa

View solution in original post

Super User II
Super User II

@Velocity 

Just out of curiosity, why do you need a summarized table to establish a 1-M relationship?

you should be able to create a 1-M just by using a Dimension Table, bridging two tables, with the field you need to filter on.

can you show a screenshot of your model with the tables/field you want to create the 1-M relationship?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@Velocity 

Request you to share your Kudoes as well. A click on the Thumps UP Icons matters a lot sometimes

Vijay Perepa

@Velocity 

Please share your Kudoes as well ! It Counts a clik on thumps up icon on my Post!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors