Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I would like to get a % of each month to sum up to 100% instead of grand total.
What I have now:
When I change from numbers to % I have like this:
But I would like to have like this:
How can I get to this?
Solved! Go to Solution.
@Anonymous ,
You want overall %
divide([measure], calculate([measure], allselected())
or
for legend column
divide([measure], calculate([measure], filter(allselected(Table), Table[Legend column] = max(Table[Legend column] ))))
or
for legend month year
divide([measure], calculate([measure], filter(allselected(Table), Table[month year] = max(Table[month year] ))))
@Anonymous ,
You want overall %
divide([measure], calculate([measure], allselected())
or
for legend column
divide([measure], calculate([measure], filter(allselected(Table), Table[Legend column] = max(Table[Legend column] ))))
or
for legend month year
divide([measure], calculate([measure], filter(allselected(Table), Table[month year] = max(Table[month year] ))))
Thank you, it's working!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!