Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4
Hi @AidanaY
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.
Hello! Thanks.
KPIs is measure.
Should I create the table? How?
Your Welcome @AidanaY
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.
Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |