Forum Discussion
Average formula
Hi Team im new to powerbi
In my sheet 1 i have a column with Average score and on my another Sheet 2 i have another column with Average score
Example
Sheet 1 Column
Score
87%
54%
45%
65%
Sheet 2 Column
Score
76%
67%
98%
98%
I want one formula to calculate two columns and give me an output of Overall Average score.
im only able to get average of one sheet.
5 Replies
Hi Salman_99 ,
Create a measure that sums both columns and divide it by the row count of both.
= DIVIDE ( SUM ( Sheet1[Score] ) + SUM ( Sheet2[Score] ), COUNTROWS ( Sheet1 ) + COUNTROWS ( Sheet2 ) )If this isn't what you're looking for, please elaborate your use case (eg, your expected result).
I have 2 sheets call and Email, on that sheet i have overall score in percentage seperately but i need one average formula to calulate both the sheets average
Hi Salman_99 ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I need an average of both the sheets
As mentioned please elaborate your use case. What is your expected result from your sample data, etc? I've provided a formula. Have you tried it? If so, why does this work for you? This post should serve as a guide - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message
