Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Domenick
Helper IV
Helper IV

Matrix Totals not making sense

Can someone tell me what on earth is PowerBI's logic here? And how can I get it to show the average of all the numbers in the row?

Domenick_1-1677601996755.png

 

 

Domenick_0-1677601937769.png

 

2 REPLIES 2
MAwwad
Super User
Super User

 

In your matrix visual, it looks like the Total column is displaying the sum of the values in each row, while the Grand Total row is displaying the sum of the values in each column.

To display the average of all the numbers in each row, you can add a new measure to your data model that calculates the average for each row, and then use that measure in your matrix visual.

Here's an example of how to create the measure:

  1. Go to the "Modeling" tab in the Power BI Desktop ribbon.
  2. Click "New Measure" and give the measure a name, such as "Row Average".
  3. In the formula bar, enter the following formula, replacing "Table" and "Value" with the names of your table and value column:

 

 
Row Average = AVERAGE('Table'[Value])
 
  1. Click "Enter" to create the measure.

Once you have created the measure, you can add it to your matrix visual by dragging it from the "Fields" pane to the "Values" area of the visual. You should then see the average value for each row in the Total column of the matrix visual.

Thanks, that does make sense but in this situation, this would create an additional column beside each existing column which is not what I want. I want one summary column.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.