Forum Discussion
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...
Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4
Hello! Thanks.
KPIs is measure.
Should I create the table? How?
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.