Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago

measure issue

Hi Team,   i am using the below measure for selecting $ and %, if you see the below screenshot, my $ value is formatted in %, is there a way to fix this? Measure 2 = IF (     SELECTEDVALUE ( Var...
Need Help
Show and Tell
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi vjnvinod ,

We will need to use the FORMAT() function to format the result, if we want to display the **%, we can use FORMAT ( ***, "0%" ), if we want to display the $**, we can use the FORMAT ( ***, "$#" ). You can refer to this blog: https://www.tutorialspoint.com/dax_functions/dax_format_function.htm to get a format type list.

Please refer to the following DAX query:

Measure =
IF (
    SELECTEDVALUE ( Table1[Column1] ) = "Variance$",
    FORMAT ( MIN ( Table2[Variance$] ), "$#" ),
    FORMAT ( MIN ( Table2[%Variance] ), "0%" )
)

The result will like below:

Best Regards,

Teige

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago

TeigeGao 

 

tried using the format fucntion before it didn't help, tried the below one as well, i am getting error

 

see the screenshot

 

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    There is no need to use MIN() function in your scenario, it is a sample, you can use FOARMAT() directly, by the way, could you please share the pbix file? 

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      7 years ago

      TeigeGao 

       

      doesn't work.

      doesn't look like you can use format function directly when you have measures for $ and %, don't get confused this with coloumns.

      variance$ and Variance% is a measure in my case & the example above you have shown is coloumns