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 Excel - average = 96%Help how to do this in Power BI?

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

Average | Microsoft Fabric Community

LuisM1
Frequent Visitor
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
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
  Not applicable
  3 years ago
  Hello! Thanks.
  KPIs is measure.
  Should I create the table? How?
  - 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.