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. It is a decimal value anywhere between 0 and 100)
I want to use 2 cards to show the average availability of the 2 entities. I tried 2 different methods for this:
The average is 100
I used a measure to find the average.
Avg1 = CALCULATE(AVERAGE('browser data'[Availability]),'http data'[Entity ID] = "HTTP_CHECK-12CD3A6E8A36AA18")
The average is again 100.
But the actual average of this is not 100. The excel average for the same entity is 98.91
I have found out that the way in which excel and Power BI calculate average is different but I not quite able to figure out how to use averagex function get the desired result.
Can anyone help please.