Reply
KiMoZ
New Member

percentage from the parent column, regardless what is the parent column as it changes

I have date from 13 columns that user can change but they need the messure to caluclate the % from total an when they expand the expand be % of the parent not from the grand total tried the below and didnt work any ideas , 

% of Parent Total =
DIVIDE(
SUM(Table[MeasureColumn]),
CALCULATE(
SUM(Table[MeasureColumn]),
ALLSELECTED(Table)
)
)

KiMoZ_0-1734187279117.png

 

 

3 REPLIES 3
lbendlin
Super User
Super User

This was impossible before Visual Calculations were introduced. Now it is trivial. read about COLLAPSE.

i want the expanded to be percentage from what is expanded from what the collapes do with that

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)