Average

[Anonymous]

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?

[grazitti_sapna]

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]

Hello! Thanks.

KPIs is measure. 

Should I create the table? How?

[grazitti_sapna]

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.

[LuisM1 · Accepted solution]

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