Forum Discussion

nrenaud's avatar
nrenaud
Helper I
6 years ago
Solved

Designating Value Types in a Measure

Hello! I am using the following measure to display data in a matrix (along with other measures). This measure displays the values I am looking for, however, some of the values are currency, some are ...
  • dedelman_clng's avatar
    dedelman_clng
    6 years ago

    Hi nrenaud  - 

     

    You should be able to use the FORMAT function around your values to get the desired result.  There's a good explanation on how it works here, including some examples: https://dax.guide/format/ 

     

     

    Fmt Measure = SWITCH(SELECTEDVALUE(MType[MType]), 
    "Amount", FORMAT(SUM(Dates[Amount]), "$#,0.00"), 
    "Percent", FORMAT(SUM(Dates[Percent]), "Percent"))

     

    Hope this helps

    David

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey nrenaud , 

 

this is not possible out of the box.

You can use format strings in calculation groups, but be aware that calculation groups are complex feature by itself, that only can be unlocked using Tabular Editor.

Here are two links that describe what you are looking for:

Hopefully, this provides some ideas on how to tackle your challenge

 

Regards,

Tom