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
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