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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Narsis
Frequent Visitor

Calculate % of subtotal per category per type in a matrix table

Hi Champions 

I have this visualisation in PB:

Narsis_1-1716243422630.png

 

Want to calulate % of each column for each country  and show it under total in the matrix table. Can anyone assist me :  something like below: 

Narsis_0-1716243375993.png

Thanks

 

2 REPLIES 2
Narsis
Frequent Visitor

Thanks Vicky, I couldn'y figure out with your solution. I am looking for someting like this (Red Circle)

Narsis_0-1716248991117.png

 

vicky_
Super User
Super User

Are you using implicit measures? if so then there an option to show subtotals %

vicky__0-1716245638611.png

 

If you only need the value to show in the totals row, then the solution might be a bit more complicated. I would use a measure instead, and do something like:
Measure = IF(HASONEVALUE(Table[Country]), 

    // your existing calculation here

    // else DIVIDE(your calculation, CALCULATE(your calculation, removefilters(Table[Country]))
)

 

    

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors