Go to the Measure property and change the aggregate function from SUM to AVG.
Related Posts
Quick Fix: SQL Server Error 3702 – Cannot Drop Database Because It Is Currently in Use
SQL Server Error 3702 is a common roadblock when attempting to drop a database that still has active connections. The…
Power BI Colloboration with SQL Server Reporting Services
Power BI and SQL Server Reporting Services (SSRS) can be integrated to provide a comprehensive reporting solution. Here’s how you…
What are the benefits of date dimension in Power BI
The Date Dimension table, often referred to as a Date Table, is a fundamental component in Power BI for handling…