Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Proud to be a Super User!
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?
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Please share your Kudoes as well ! It Counts a clik on thumps up icon on my Post!
Proud to be a Super User!
Request you to share your Kudoes as well. A click on the Thumps UP Icons matters a lot sometimes
Vijay Perepa
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |