This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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%
Thanks in advance! I'm pretty new with PowerBI so maybe I missed the solution somewhere.
Solved! Go to Solution.
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
)
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
)
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,
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 35 | |
| 32 | |
| 25 | |
| 22 | |
| 18 |
| User | Count |
|---|---|
| 65 | |
| 35 | |
| 32 | |
| 25 | |
| 23 |