Forum Discussion

maurcoll's avatar
maurcoll
Helper IV
11 months ago
Solved

help with text box including measures

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([Chan...
Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    11 months ago

    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
maurcoll's avatar
maurcoll
Helper IV
11 months ago

That works perfectly thank you