Go to the Measure property and change the aggregate function from SUM to AVG.
Related Posts
How Gateway affects the performance of Reports in Power BI
The Power BI Gateway plays a crucial role in the performance of reports, especially when they rely on on-premises data…
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…