Forum Discussion

Molin's avatar
Molin
Helper 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
Helper 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
Super 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

  • Molin's avatar
    Molin
    Helper I
    4 years ago

    Hi, 

    Thanks a million. I got it solved with the SELECTEDMEASUREFORMATSTRING()