measure issue

[vjnvinod]

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 ( Varianceselection[select]) = "Variance$", [Variance$],([%Variance]))

[TeigeGao]

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]

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

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]

@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

[vjnvinod]

@Zubair_Muhammad 

any solution for this formatting issue, due to measure?