Format integer number with the thousands icon selected

[MTrullàs]

Hello,

I have two metrics. Both have the same format: integer number with the thousands icon selected. One metric is displayed in the format 3.313 while the other is shown as 11 mil. I want the second metric to be displayed like the first. I don't want "mil"; I want to display 10.627. Would someone be so kind as to help me?

Thank you very much

[Ritaf1983 · Accepted solution]

Hi @MTrullàs 
You can modify your measure with the format function.
kpi_total_1 = format([your measure 1]+[your measure 2] + [your measure 3] , desired format) .

more information here :

https://learn.microsoft.com/en-us/dax/format-function-dax

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @MTrullàs 
You can modify your measure with the format function.
kpi_total_1 = format([your measure 1]+[your measure 2] + [your measure 3] , desired format) .

more information here :

https://learn.microsoft.com/en-us/dax/format-function-dax

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[MTrullàs]

Hello @Ritaf1983 

Thank you very much for your assistance. It works perfectly.

I do have a question, though. Why is it that when the two metrics are identical, the visualizations appear different?

Thanks for your comment.

[Ritaf1983 · Accepted solution]

Hi @MTrullàs 
This is happening because format isn't a part of a measure logic.

So every measure has been formatted separately
Glad to help 🙂

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly