Same measure is displayed with different formats

[qmestu]

Hi,

I have a measure that i created which is just the sum of a column. Whenever this measure is applied to a chart, the format of the number is without a separator for thousands.

original_measure=calculate(sum([value],condition>1)

However if i create another measure using this first measure, the format changes and there is now a separator for thousands

new_measure=calculate(original_measure,condition_2=1)

Both measures are setup as decimal numbers, so i'm guessing this shouldn't happen. I also don't want to include formatting options inside the Dax formula.

Thanks.

[Idrissshatila · Accepted solution]

Hello @qmestu ,

click on the measure then click on the separator icon here and it will format the values to show it.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[qmestu]

Yeah, so obvious. Thank you!