topic Re: Calculating average between several columns in DAX Commands and Tips

Calculating average between several columns

PC2022 — Mon, 24 Mar 2025 18:14:13 GMT

Trying to calculate the average number between 3 columns. I get an error "the count function only accepts a column reference as an argument"

ScheduleAvg = (AVERAGE(crb87_consultantevaluation[crb87_timelinessofprojectphasesubmittalsd]) + AVERAGE(crb87_consultantevaluation[crb87_timelysubmittalofprogressreportsandschedud]) + AVERAGE(crb87_consultantevaluation[crb87_timelinessofprojectphasedeliverablesandord])) / COUNT(crb87_consultantevaluation[crb87_timelinessofprojectphasesubmittalsd]) + COUNT(crb87_consultantevaluation[crb87_timelysubmittalofprogressreportsandschedud] + COUNT(crb87_consultantevaluation[crb87_timelinessofprojectphasedeliverablesandord]))

Re: Calculating average between several columns

lbendlin — Mon, 24 Mar 2025 19:04:34 GMT

Did you mean to use COUNTROWS() ?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Calculating average between several columns

techies — Mon, 24 Mar 2025 19:16:34 GMT

Hi PC2022 please check this

ScheduleAvg =

AVERAGEX(

crb87_consultantevaluation,

VAR NonBlankCount =

COUNT(crb87_consultantevaluation[Timeliness of Phase Submittals (A)]) +

COUNT(crb87_consultantevaluation[Timeliness of Deliverables (C)]) +

COUNT(crb87_consultantevaluation[Timely Submittal of Reports (B)])

VAR TotalValue =

crb87_consultantevaluation[Timeliness of Deliverables (C)] +

crb87_consultantevaluation[Timeliness of Phase Submittals (A)] +

crb87_consultantevaluation[Timely Submittal of Reports (B)]

RETURN

IF(NonBlankCount > 0, TotalValue / NonBlankCount, BLANK())

)

Re: Calculating average between several columns

PC2022 — Mon, 24 Mar 2025 20:32:12 GMT

it is returning the same number for each project and phase

Re: Calculating average between several columns

pankajnamekar25 — Tue, 25 Mar 2025 04:26:10 GMT

Please try this

Re: Calculating average between several columns

PC2022 — Tue, 25 Mar 2025 18:56:31 GMT

Not working either

Re: Calculating average between several columns

Anonymous — Wed, 26 Mar 2025 15:03:47 GMT

Hi PC2022,

As suggested by the super user, please provide sample data that demonstrates your issue, along with the expected outcome. This will help us better understand the problem and provide the right guidance to resolve it.

Regards,

Vinay Pabbu

Re: Calculating average between several columns

PC2022 — Wed, 26 Mar 2025 20:03:18 GMT

This worked! Thank you!