topic Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function in DAX Commands and Tips

Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Tue, 17 Jan 2023 05:04:01 GMT

How should I modify the function below to avoid the error message.

Measure = SUMMARIZE(GROUPBY(Productivity, Productivity[employee name], "AvgOfgrade", AVERAGE(Productivity[grade awarded])))

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Jihwan_Kim — Tue, 17 Jan 2023 05:32:22 GMT

Hi,

I am not 100% sure if the below DAX formula can provide the desired output of the calucaluted table, but please try something like below.

DAX sample = SUMMARIZE ( GROUPBY ( Productivity, Productivity[employee name] ), "AvgOfgrade", AVERAGE ( Productivity[grade awarded] ) )

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

FreemanZ — Tue, 17 Jan 2023 05:34:50 GMT

hi Anonymous

try like:

Measure =

SUMMARIZE(

Productivity,

Productivity[employee name],

"AvgOfgrade",

CALCULATE(AVERAGE(Productivity[grade awarded]))

)

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Tue, 17 Jan 2023 05:47:10 GMT

Got the error:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Tue, 17 Jan 2023 05:48:34 GMT

No error but does not return employee name. Please modify it to also show employee name.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

FreemanZ — Tue, 17 Jan 2023 05:59:46 GMT

hi Anonymous

are you expecting something like this:

Measure = AVERAGEX( VALUES(Productivity[employee name]), Productivity[grade awarded] )

if not, could you describe your expectation on the measure?

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Tue, 17 Jan 2023 06:04:47 GMT

error:

A single value for column 'grade awarded' in table 'Productivity' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

FreemanZ — Tue, 17 Jan 2023 06:45:22 GMT

hi Anonymous

try like:

Measure = AVERAGEX( VALUES(Productivity[employee name]), SUM(Productivity[grade awarded]) )

please consider @someone, if you seek further suggestions.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Tue, 17 Jan 2023 11:08:11 GMT

Error:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Tue, 17 Jan 2023 11:12:50 GMT

No error returned but does not list any names of employees.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Wed, 18 Jan 2023 08:11:41 GMT

Hi Anonymous ,

When you use the function SUMMARIZE, it will return a table instead of a value. You can get more detail about the function SUMMARIZE in this official documentation. You can update the formula of measure as below and check if it can return your expected result... Please find the details in the attachment.

Measure = VAR _tab = SUMMARIZE ( Productivity, Productivity[employee name], "AvgOfgrade", CALCULATE ( AVERAGE ( Productivity[grade awarded] ), Productivity[employee name] = EARLIER ( Productivity[employee name] ) ) ) RETURN AVERAGEX ( _tab, [AvgOfgrade] )

If the above one can't help you, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Wed, 18 Jan 2023 14:11:19 GMT

Error: The syntax for 'RETURN' is incorrect.

So sorry for the bother.

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

tamerj1 — Wed, 18 Jan 2023 15:09:46 GMT

Hi Anonymous

Can you please present sample of the shape of the expected results?

Re: Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function

Anonymous — Thu, 19 Jan 2023 01:25:50 GMT

Hi Anonymous ,

It seems that you got some error message when you used the formula which I provided... Could you please provide some raw data in your tables (exclude sensitive data) with Text format, the screenshot with the error message and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards