help with text box including measures

[maurcoll]

Hi

I have the following measure which doesnt quite do what i need it to

Text Box = "In the last 12 months " & SELECTEDVALUE ([country]) & " is " &[change]& " with a difference of "& FORMAT([Change % - Date], "#,#%") & " compared to the previous 12 months"

I need to say if nothing is selected then All Countries but if one is selected then the selected value and also the format for the percentage is rounding i need it to be 2 decimal places 1.50% not 2% or -1.50% not -2%

Thank you

[maurcoll]

That works perfectly thank you

[GeraldGEmerick · Accepted solution]

@maurcoll Try the following:

Text Box = 
VAR _Country = IF( HASONEVALUE( 'Table'[country] ), SELECTEDVALUE( [country] ), "All countries" )
VAR _IsAre = IF( HASONEVALUE( 'Table'[country] ), "is", "are" )
VAR _Format = "0.00%;-0.00%;0.00%"
VAR _Return = "In the last 12 months " & _Country & _IsAre &[change]& " with a difference of "& FORMAT([Change % - Date], _Format) & " compared to the previous 12 months"
RETURN _Return