Forum Discussion
Saurabh129
3 years agoFrequent Visitor
Selected Value: parameter for measures Error - Need help
I have a Parameter table which has 3 measures of having 3 different revisions of forecasts coming from 3 different tables. These 3 measures contain 3 different revisions of forecasts ($) ...
- 3 years ago
Hi Saurabh129
The syntax of SELECTEDVALUE & SWITCH is not quite right, and also SELECTEDVALUE cannot be used with the first column of a Field Parameter table (see this article).
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.
Regards
Saurabh129
3 years agoFrequent Visitor
Thank you so much for your help
It worked