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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
PowerBI_User23
Frequent Visitor

Row Level Total

 Hi ,

 

I need help to show row level total for particulr column for example as show below:

I just wanted to show total at row level only for first column that is BASE/NEW

PowerBI_User23_1-1685220689905.png

 

but when i am turning on row level total its showing me total at each column , that i dont need .

PowerBI_User23_2-1685220867876.png

 

Let me know if there is any soluntion for thsi 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@PowerBI_User23 I believe that under Row subtotals there is a toggle for Per row level that you can turn on and then select the row you want.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
PowerBI_User23
Frequent Visitor

Hi @Greg_Deckler  Thankyou for the reply .

I have tried that option but its still showing the other total of the column , you can see in the below picture .

PowerBI_User23_0-1685304173775.png

 

 

Greg_Deckler
Community Champion
Community Champion

@PowerBI_User23 I believe that under Row subtotals there is a toggle for Per row level that you can turn on and then select the row you want.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi,

 

Did that work for you. I can see the toggle button but there is no action when we are trying to select different row levels

 

Thansk, Anusha

Hi @apuchakayala , No its working for me , it still showing me total level for each column

Yeah I was expecting it to show on only the column that I wanted , but it still showing on all columns.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.