Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.