Forum Discussion

Atif's avatar
Atif
Resolver I
7 years ago
Solved

Average

The columns that I have as raw data are (a) KPIs, (b) Indicator, (c) Weightage, (d) Past Performance, (e) Target, (f) Actual Result, (g) Assessee, and (h) Assessor. The different tables are later clu...
Need Help
Tips and Tricks
Tutorial Requests
  • Iamnvt's avatar
    Iamnvt
    7 years ago

    oh, sorry, I forgot something.

    how about this:

    Sum of Average = AVERAGEX(VALUES('All'[Assessee]), CALCULATE(SUM('All'[Score])))

  • Atif's avatar
    Atif
    7 years ago

    Really appreciated @lamnvt. 

     

    Your measure is much simpler and most importantly is giving the desired result.

     

    Just minutes ago I got the solution by using the following measure.

     

    Average =
    VAR AvgScore = AVERAGE('All'[Score])

    RETURN
    IF(HASONEVALUE('All'[KPIs]),
        AvgScore,
            SUMX(VALUES('All'[KPIs]), AvgScore))
Iamnvt's avatar
Iamnvt
Continued Contributor
7 years ago

oh, sorry, I forgot something.

how about this:

Sum of Average = AVERAGEX(VALUES('All'[Assessee]), CALCULATE(SUM('All'[Score])))

Atif's avatar
Atif
Resolver I
7 years ago

Really appreciated @lamnvt. 

 

Your measure is much simpler and most importantly is giving the desired result.

 

Just minutes ago I got the solution by using the following measure.

 

Average =
VAR AvgScore = AVERAGE('All'[Score])

RETURN
IF(HASONEVALUE('All'[KPIs]),
    AvgScore,
        SUMX(VALUES('All'[KPIs]), AvgScore))