Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI Average is different from Excel Average

I have a table which shows the availablilty of 2 Entities (2 locations for each) for every hour for the last 35 days. PFB a screensnip of the table. (the availablity values are not always 100....
Need Help
  • ahmadibrahimbus's avatar
    ahmadibrahimbus
    4 years ago

    Dear Anonymous ,

    Power BI calculate Average as an (arithmetic mean) of all the numbers in the specified column,However when you are using the average function in the pivot table you are calculating the average of average.

    so, if you want to have the same calculation as excel,use the below formula:

    AveragePerCity =

    AVERAGEX(

    VALUES('browser data'[Availability]), 

        CALCULATE(AVERAGE('browser data'[Availability]),'http data'[Entity ID] = "HTTP_CHECK-12CD3A6E8A36AA18"))

    hope this helps .

    please mark it as a solution if it's solved.

ahmadibrahimbus's avatar
ahmadibrahimbus
Icon for Resolver III rankResolver III
4 years ago

Dear Anonymous ,

Power BI calculate Average as an (arithmetic mean) of all the numbers in the specified column,However when you are using the average function in the pivot table you are calculating the average of average.

so, if you want to have the same calculation as excel,use the below formula:

AveragePerCity =

AVERAGEX(

VALUES('browser data'[Availability]), 

    CALCULATE(AVERAGE('browser data'[Availability]),'http data'[Entity ID] = "HTTP_CHECK-12CD3A6E8A36AA18"))

hope this helps .

please mark it as a solution if it's solved.