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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm trying to control the decimal places in 'percent of column total'. I've read that the way to do this is to make a measure.
In the examples I've seen it involves doing a SUM of something. I'm trying to show percentage breakdown of values and then split this into year columns.
How would you construct this measure?
Solved! Go to Solution.
Hi,
Write these measures
Count of priority names = COUNTA(RawJiraDataJSON[priority.name])Contribution = [Count of priority names]/CALCULATE([Count of priority names],ALL(RawJiraDataJSON[priority.name]))
Select the second measure and click on % icon under Modelling.
Hope this helps.
Hi,
Select the measure that you have written for % and in the ribbon click on the % button.
I haven't written the measure yet, the existing % is the auto function for show value as percent of column total.
I want to replace this with a measure that I can control the decimal places with.
Hi,
Write these measures
Count of priority names = COUNTA(RawJiraDataJSON[priority.name])Contribution = [Count of priority names]/CALCULATE([Count of priority names],ALL(RawJiraDataJSON[priority.name]))
Select the second measure and click on % icon under Modelling.
Hope this helps.
Fantastic!
Thanks I was struggling with that one for a while.
You are welcome.
Hi,
Share the link from where i can download your PBI file.
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!