Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rotemshan
Helper I
Helper I

Argument '9' in SUMMARIZE function is required

Hi, 

 

I came across some issue which I can't understand where it went wrong. 

I built a formula to count and summarize a range of values in a column (I created a new table)

The result I expect is 

Number of values between 0 to 6

Number of values between 7 to 8

Number of values between 9 to 10 

 

I keep getting the error of "Argument '9' in SUMMARIZE function is required" 

How should I fix it? 

 

Attached a screenshot and the formula underneath 

 

Rotemshan_0-1646963104098.png

 

Recieve_table =
SUMMARIZE (
Merge1,
Merge1[Response_Details.Likely to Recommend NPS.1],
"0-6", CALCULATE (
COUNT (Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 6
)
,
"7-8", CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] > 6
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 8
)
,
"9-10", CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] > 8
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
)
,
)

 

2 ACCEPTED SOLUTIONS
Kucrapok
Helper I
Helper I

You need to remove the last comma before the parenthesis

View solution in original post

Rotemshan
Helper I
Helper I

PERFECT !!!

Thank you 

View solution in original post

2 REPLIES 2
Rotemshan
Helper I
Helper I

PERFECT !!!

Thank you 

Kucrapok
Helper I
Helper I

You need to remove the last comma before the parenthesis

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.