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

hi,

 

you can try the following:

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

 

Atif's avatar
Atif
Resolver I
7 years ago

Hi there Iamnvt ,

 

Sum of Average = AVERAGEX(VALUES('All'[Assessee]), 'All'[Score]) can't be done.

 

The syntax is "table" and then "expression".

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