Forum Discussion

Molin's avatar
Molin
Icon for Helper I rankHelper I
4 years ago
Solved

Currency Format

Dear Community,  I am working on a report where the users should be able to switch between 3 different currencies.  I have created a simple table (CurrencyMeasure) and the following DAX command...
Currency
DAX
Format
switch
  • johnt75's avatar
    johnt75
    4 years ago

    I think you should be able to use SELECTEDMEASUREFORMATSTRING() as the default in a SWITCH statement, so unless you explicitly specify a new format string for a measure it will use its original setting

Molin's avatar
Molin
Icon for Helper I rankHelper I
4 years ago

Hi johnt75, 

Thanks great feedback. I have looked into using Tabular Editor with Calculating groups. However, it tends to format all measures (some which are not currencies) when I use SELECTEDMEASURE(). Do you know a way around this? 

Thanks in advance.

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    The format expression itself can be DAX, so you could put a SWITCH( SELECTEDMEASURENAME() in there and return different format strings dependent on which measure was currently in context

    • Molin's avatar
      Molin
      Icon for Helper I rankHelper I
      4 years ago

      Hi johnt75 , 

      When I try to use either SWITCH or IF I am able to format the selectedmeasures, however I can find a way to keep the normal format for all other measure. I have a table where I want the Calculated group to format some columns with Sales and Budget but the rest of the measures should keep their normal format. 

      How do I do that? 

      Thanks in advance. 

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        4 years ago

        I think you should be able to use SELECTEDMEASUREFORMATSTRING() as the default in a SWITCH statement, so unless you explicitly specify a new format string for a measure it will use its original setting