Average formula

[Salman_99]

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.

[Salman_99]

I need an average of both the sheets

[danextian]

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/144... 

[danextian]

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).

[Salman_99]

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

[Anonymous]

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