Go to the Measure property and change the aggregate function from SUM to AVG.
Related Posts
How to change the storage mode of a table in Power BI
In Power BI, you can change the storage mode of a table by modifying the data connectivity settings in Power…
SQL Server – Why SSAS Cube is needed?
Following are the reasons for choosing the SSAS Cube High Performance Multi dimensional analysis Built-in advanced time-calculation Stores hierarchy data…
SSRS Issue – Unable to deploy the bulk RDL files
1. There is a property called maxRequestLength which needs to be increased in the machine and web.config file which is…