Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Var Formula error

Hi All,   I have a measure where the user would be able to display a value of their choice within a linked MAtrix table.    My issue is that one of the option links to a percent measure but the o...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    If you just want to show the number as a percentage, you can try this formula.

    Selected Metric =
VAR MySelection =
    SELECTEDVALUE ( 'Select Metric'[Measure] )
RETURN
    SWITCH (
        MySelection,
        "Volumes", [Volume YTD],
        "Forecast", [Cumulative Forecast],
        "% Forecast Met", FORMAT ( [Ytd % Forecast Met], "0.00%" ),
        "Variance", [Cumulative Variance],
        [Volume YTD]
    )

    Var-Formula-error

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

If you just want to show the number as a percentage, you can try this formula.

Selected Metric =
VAR MySelection =
    SELECTEDVALUE ( 'Select Metric'[Measure] )
RETURN
    SWITCH (
        MySelection,
        "Volumes", [Volume YTD],
        "Forecast", [Cumulative Forecast],
        "% Forecast Met", FORMAT ( [Ytd % Forecast Met], "0.00%" ),
        "Variance", [Cumulative Variance],
        [Volume YTD]
    )

Var-Formula-error

 

Best Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Awesome! Thank you, that's done the job.

     

    Thanks