Help with Grand total for matrix visual.

Hi lbendlin 

Thank you for your reply. I am trying to fix my grand total for my matrix visual. Clearly my grand total is not correct as shown below

What I am trying is to find a way to show the total for each category (i.e Total for Revenue and Total for No of Customers) in the grand total (if possible, IDK 😞 ) like shown in image below.

I am not being able to attach a sample pbix file here.
TIA 🙂

Hi, mgb-nav-pbi ;

You could add a blank column add rows,then create a measure.

1.create a blank column.

Column = 

2.add the matrix rows.

3. then create a measure.

Measure = 
IF(ISINSCOPE('financials'[Column]),
   IF(ISINSCOPE('financials'[Country]),
    SUM(financials[Sale Price]),
      CALCULATE(SUM(financials[Sale Price]),FILTER('financials',[Product]="Amarilla"))),
         CALCULATE(SUM(financials[Sale Price]),FILTER('financials',[Product]="Carretera")))

The final output is shown below:

Or

If it not solve your problem,you could copy table in your reply.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.