Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average

Good day!   Please help!   How to calculate the average of % from 4 different tables??  Table 1 - KPI 1 - 100% Table 2 - KPI 2 - 100% Table 3 - KPI 3 - 100% Table 4 - KPI 4 - 78%   In the E...
Need Help
  • LuisM1's avatar
    LuisM1
    3 years ago

    Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4

grazitti_sapna's avatar
grazitti_sapna
Super User
3 years ago

Hi Anonymous 
There are several ways for achieving this. One of them are:-
CombinedTable = UNION('Table 1', 'Table 2', 'Table 3', 'Table 4')
Then
AveragePercentage = AVERAGE(CombinedTable[KPI])

Thank you
Hope this will help you.


  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello! Thanks.

    KPIs is measure. 

    Should I create the table? How?

    • grazitti_sapna's avatar
      grazitti_sapna
      Super User
      3 years ago

      Your Welcome Anonymous 
      You can create this for all the tables:-

      KPI 1 Measure = SELECTEDVALUE('Table 1'[KPI 1])  -----Create this measure all the four tables


      Thn create an AVG measure:-
      Average KPI = AVERAGE('Table 1'[KPI 1 Measure], 'Table 2'[KPI 2 Measure], 'Table 3'[KPI 3 Measure], 'Table 4'[KPI 4 Measure])

      Hope this will help you.