Selected Value: parameter for measures Error - Need help

Question

I have a Parameter table which has 3 measures of having 3 different revisions of forecasts coming from 3 different tables.&nbsp;These 3 measures contain 3 different revisions of forecasts ($) I created a slicer using this Parameter Table&nbsp;&nbsp;Then I tried to create a measure&nbsp; (Forecast $)&nbsp; which will show the Forecast value $ depending upon which Forecast measure (revision) is picked.&nbsp; (measure below)Forecast $ =SELECTEDVALUE (SWITCH (TRUE (),SELECTEDVALUE ( 'Forecasts'[Forecasts] = "Forecast 23 BP $", [Forecast 23 BP $]) ,SELECTEDVALUE ( 'Forecasts'[Forecasts] = &nbsp;"Forecast 1Q23RF $", [Forecast 1Q23RF $]) ,SELECTEDVALUE ( 'Forecasts'[Forecasts] = &nbsp;"Forecast 2Q23RF $", [Forecast 2Q23RF $]) ,BLANK())Somehow the measure above is not working and giving errorCan someone please help hereThank you so much !!

owenauger · Accepted Answer

Hi&nbsp;Saurabh129&nbsp;
The syntax of SELECTEDVALUE &amp; SWITCH is not quite right, and also SELECTEDVALUE cannot be used with the first column of a Field Parameter table (see this article).
&nbsp;
Here is one way you could rewrite it:
Forecast $ =
VAR FieldParameterSelection =
    IF (
        COUNTROWS ( 'Forecasts' ) = 1,
        VALUES ( 'Forecasts'[Forecasts] )
    )
RETURN
    SWITCH (
        FieldParameterSelection,
        "Forecast 23 BP $", [Forecast 23 BP $],
        "Forecast 1Q23RF $", [Forecast 1Q23RF $],
        "Forecast 2Q23RF $", [Forecast 2Q23RF $]
        -- BLANK() will be returned in the case of no match
    )
I'm assuming you're creating this measure so that you can write DAX expressions that reference it elsewhere, or do something that doesn't work with the normal behaviour of field parameters.
&nbsp;
Regards

Forum Discussion

Related content

Parameter selection for charts

Dynamic Total Measure Dependent on Selected Parameters ?

Sum dynamic parameter fields multiple selected parameter

Parameter: Selected Value doesn’t updated

Parameter: Fields selected value