Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
70 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |