Solved: Calculating Share in Segment

Anonymous · ‎12-21-2017

Hi,

T have the Matrix below. First photo the Matrix is collapsed in the second it is expanded. The issue is regarding the last column. In the first photo I'm happy with the lines summing up to 100, but when I expand the Matrix I would like to see the red lines summing up to 100

I've tried different measures, but can't get my head around it.

I really hope you can help!

Br Kent

v-chuncz-msft · ‎12-21-2017

@Anonymous,

Check if the following thread helps.

https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/td-p/312802

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎12-21-2017

@Anonymous,

Check if the following thread helps.

https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/td-p/312802

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Calculating Share in Segment

Helpful resources

FabCon Global Hackathon

Power BI Monthly Update - September 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

FabCon is coming to Atlanta