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! Learn more

Reply
robm135
Helper I
Helper I

Measure for controlling decimal places in column total

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?

 

Capture.PNG

1 ACCEPTED 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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
Ashish_Mathur
Super User
Super User

Hi,

Select the measure that you have written for % and in the ribbon click on the % button.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Fantastic!

Thanks I was struggling with that one for a while. 

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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