Go to the Measure property and change the aggregate function from SUM to AVG.
Related Posts
SQL Server 2012 High Availability and Disaster Recovery (HADR) Options
SQL Server 2012 offers flexible HADR solutions to ensure data availability and minimize downtime. With features like AlwaysOn, failover clustering,…
What are the advanatges of NOSQL over SQL
NoSQL (Not Only SQL) databases offer several advantages over traditional SQL (Structured Query Language) databases in certain use cases. Here…
How to migrate SQL Server database to Azure SQL Server database
Migrating a SQL Server database to Azure SQL Database involves several steps. Here’s a general outline of the process: Assessment…