Forum Discussion

MTrullàs's avatar
MTrullàs
Helper III
2 years ago
Solved

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 s...
  • Ritaf1983's avatar
    2 years ago

    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's avatar
    Ritaf1983
    2 years ago

    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