Forum Discussion
Format integer number with the thousands icon selected
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
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
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
3 Replies
- Ritaf1983Super User
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