cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Solution Sage
Solution Sage

Re: Error in SUMMARIZECOLUMNS

@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
Highlighted
Solution Sage
Solution Sage

Re: Error in SUMMARIZECOLUMNS

@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

Highlighted
Super User II
Super User II

Re: Error in SUMMARIZECOLUMNS

@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.






Highlighted
Solution Sage
Solution Sage

Re: Error in SUMMARIZECOLUMNS

@Velocity 

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

Vijay Perepa

Highlighted
Solution Sage
Solution Sage

Re: Error in SUMMARIZECOLUMNS

@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!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors