The process of calculating the sum of average in Power BI involves the following steps:
Select the table or data that you want to calculate the sum of average for.
Go to the "Visualizations" pane and choose the "Table" visualization.
Drag and drop the relevant fields into the "Values" panel.
Click on the drop-down arrow next to the field you want to average and choose "Average" from the list.
Click on the "Fields" pane and drag the same field into the "Values" panel again.
Click on the drop-down arrow next to the field you just added and choose "Sum" from the list.
The sum of average will be displayed in the table visual.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-06-12 11:00:00 +0000
Seen: 13 times
Last updated: Apr 24 '21
For some rows, the Total or Grand Total is not displayed in the Power BI matrix.
Can you assist me with creating a calendar table in POWER BI?
How can a button be made to export data to Excel in Power BI?
What are two ways to measure in Power BI?
What is the method to switch on and off?
What is the method for linking modified data in Power BI without encountering errors?
What does it mean when the previous year field is empty in Power BI?