Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Grand Total in Matrix Table

Hi There,


I am facing an issue in Matrix table where i have one column which consist of two groups or two values (e.g  Table 1 consist of  Food Items which have "Apple" and "Mango") and i want to show total of Apple and Grand total only in matrix table week wise .




Can anyone help how can we achieve this ? @amitchandak @Ashish_Mathur @jihwan_kim



Super User
Super User


You may download my PBI file from here.

Hope this helps.


Ashish Mathur

View solution in original post

Super User
Super User


You may download my PBI file from here.

Hope this helps.


Ashish Mathur

Hi @Ashish_Mathur ,


Thank you ever so much for your help. Appreicate it !

Can you also help how can i achieve Apple% =(Total of Apple/Grand Total) just below Grand Total.


Please see below desire result :




You are welcome.  I do not know how to do that.  I think there can only be 1 Grand total row.  Let's wait for someone else to contribute. 

Ashish Mathur

No Problem, Really appreicate your inputs.


Cheers !

Thank you.

Ashish Mathur
Super User
Super User

@ash_cool10 , You have to create a table like the one suggested in blog. You can directly use with with you table many to many join


A new Table

Food Item , Fod Item Group

Apple, Apple

Apple , Apple + Mango

Mango, Apple + Mango


If need add

Mango, Mango


Not use this tin visual with filter Apple, Apple + Mango

Hi @amitchandak ,


Thank you for your prompt response.


I tried to create the same as you suggested however its not going to solve my issue as once i select "Select All /Single Select on any food item but its not going to give me desire result " beacause if i select any one of the values from new table its going to select single field and grand total will show only that item value however i want only Apple selected in field and Grand Total will be of (Apple +Mango) week wise.


Can you please help me on this ?


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors