Format Sum measure to have comma

blowers — Fri, 17 Nov 2023 09:33:58 GMT

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

Re: Format Sum measure to have comma

lukiz84 — Fri, 17 Nov 2023 09:58:39 GMT

just set the measure format right?

Re: Format Sum measure to have comma

blowers — Fri, 17 Nov 2023 10:07:26 GMT

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

topic Re: Format Sum measure to have comma in DAX Commands and Tips

Format Sum measure to have comma

Re: Format Sum measure to have comma

Re: Format Sum measure to have comma