How do I get the average of something to display correctly?

[dinosainsburys]

Hi all,

So I have a table of Business Application Services. They have two columns:

- One with how many servers they have

- One with how many servers is monitored

- The monitoring coverage (a simple DAX formula which divides monitored servers / how many servers)

The value should be 29%, but Power BI is calculating it as 64%. Any ideas why? Any alternative calculation I can use? 

[freginier · Accepted solution]

Hey there!

I think if you use this formula instead it should work: (Sum of monitored servers) / (Sum of total servers)

You can write it like this in DAX: Monitoring_Coverage = DIVIDE(SUM('Table'[Monitored Servers]), SUM('Table'[Total Servers]))

Hope this helps!

Zoe 😁😁

[ahmedoye · Accepted solution]

Hi, try a measure like this:

AVERAGEX(Table, Table[Monitored Servers] / Table[No of Servers])

If this works, kindly mark this as solution to make it easy for anyone with similar issue find the solution

[freginier · Accepted solution]

Hey there!

I think if you use this formula instead it should work: (Sum of monitored servers) / (Sum of total servers)

You can write it like this in DAX: Monitoring_Coverage = DIVIDE(SUM('Table'[Monitored Servers]), SUM('Table'[Total Servers]))

Hope this helps!

Zoe 😁😁