Hi,Is there any easy way to have a total sum for the measured values at the bottom of the table?

If you click into the visual options for the matrix. You should be able to turn subtotals and totals on. Surprised though it's not on by default.

unfortunately, i couldn't find the total or subtotal !!

Few questions. Is it a matrix or a table?Are you using the preview visual pane?

Albawani First, check if the column that you are placing as values is in number or currency format. Then, you can turn on the total as follows for matrix visual.

Sum of Measure values | Microsoft Fabric Community

15 Replies

bcdobbs
Community Champion
4 years ago
If you click into the visual options for the matrix. You should be able to turn subtotals and totals on. Surprised though it's not on by default.
- Albawani
  Frequent Visitor
  4 years ago
  unfortunately, i couldn't find the total or subtotal !!
  - bcdobbs
    Community Champion
    4 years ago
    Few questions.
    
    Is it a matrix or a table?
    Are you using the preview visual pane?
Fowmy
Super User
4 years ago
Albawani

First, check if the column that you are placing as values is in number or currency format. Then, you can turn on the total as follows for matrix visual.
- Albawani
  Frequent Visitor
  4 years ago
  I couldn't find where to check the value type ! is it normal with Matrix table ?!
  since it;s a measure value, would you suggest casting the measure as currency format ?
bcdobbs
Community Champion
4 years ago
Have to say, a bit confused! Can you send a screen shot of your format pane?
- Albawani
  Frequent Visitor
  4 years ago
  Here it;s:
  - bcdobbs
    Community Champion
    4 years ago
    Does your measure always return either a number or a blank? Can you send it's definition over.
    
    With the matrix selected click on the paint roller icon and send a screen shot of what is then displayed.
    
    lastly with the model selected if you click on modelling at top what format is displayed for it?
PaulDBrown
Community Champion
4 years ago
Add a new meaure:

Total = [measure 1] + [measure 2] + [measure 3]…
- Albawani
  Frequent Visitor
  4 years ago
  I did this but it's unprofessional
  - PaulDBrown
    Community Champion
    4 years ago
    If the values in the matrix are different measures, you need a new measure for the total of all measures. It's not "unprofessional "; it's how DAX works.
Anonymous
Not applicable
4 years ago
Hi Albawani ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards