Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
blowers
Frequent Visitor

Format Sum measure to have comma

Hi folks,

 

I am using the following measure that sums 2 counts that are already formatted as numbers with a comma. However the measure does not display the data with a comma.

 

Measure = calculate(sum(table[count_column_1) + sum(table[count_column_2]))
 
Is there a formatting logic i can use to add the column in so the data looks like 1,234 instead of 1234, or 12,345 instead of 12345? The data will also show up to 7 digits, so 2000000 should be displayed as 2,000,000.
 
Thanks!
Blowers
1 ACCEPTED SOLUTION
lukiz84
Memorable Member
Memorable Member

just set the measure format right?

View solution in original post

2 REPLIES 2
blowers
Frequent Visitor

ah yeah, not sure how i missed that 😀 thanks!

lukiz84
Memorable Member
Memorable Member

just set the measure format right?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.