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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Ktt
Frequent Visitor

Percentage of parent column total (parent row total)

It is possible to show the % of column total (row total).
Is it also possible show the % of parent column total (parent row total) ? 

For example:

We have a number of shops: Shop1, Shop2, Shop3, .... that all sell ice cream.
There is a wide variety of ice cream flavours: vanilla, chocolate, caramel...
What I need to know is the % percentage of flavours sold per month.

The first table has the count of each ice cream flavour.

The second table shows the percentage of the row total, that means for example if you sum up the % of Shop1 you get 100%.
This is what I have in PowerBI at the moment.

The third table is what I need to get in PowerBI. 
As you can see Shop1 sold 50 chocolate ice creams in June, the % of chocolate ice creams in June is 50/(50+27)= 65%


icecreamiscream.png

Thanks in advance! I'm pretty new with PowerBI so maybe I missed the solution somewhere.




1 ACCEPTED SOLUTION
Ktt
Frequent Visitor

FOUND A SOLUTION!!!!
I did everything that was shown here
https://dwhgeek.wordpress.com/2015/01/18/percent-of-parent-in-hierarchy-dax/

Only replaced SUM with COUNT.
So alltogether it looked smth like this

ParentMeasure =
CALCULATE(
COUNT(Table[flavour]),ALL(Table[flavour])
)

RatioToParent =
COUNT(Table[flavour])/
ParentMeasure
)

View solution in original post

2 REPLIES 2
Ktt
Frequent Visitor

FOUND A SOLUTION!!!!
I did everything that was shown here
https://dwhgeek.wordpress.com/2015/01/18/percent-of-parent-in-hierarchy-dax/

Only replaced SUM with COUNT.
So alltogether it looked smth like this

ParentMeasure =
CALCULATE(
COUNT(Table[flavour]),ALL(Table[flavour])
)

RatioToParent =
COUNT(Table[flavour])/
ParentMeasure
)

v-sihou-msft
Microsoft Employee
Microsoft Employee

@Ktt

 

If your question is solved, please put your solution in a "REPLY" instead of editing your question context so that you/moderator can mark your thread as "Solved".

 

Regards,

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors