Calculating average between several columns

[PC2022]

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]))

[v-vpabbu]

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

[pankajnamekar25 · Accepted solution]

Please try this

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

[PC2022]

This worked! Thank you!

[PC2022]

Not working either

[techies]

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())

)

[PC2022]

it is returning the same number for each project and phase

[lbendlin]

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...