Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ($)
I created a slicer using this Parameter Table
Then I tried to create a measure (Forecast $) which will show the Forecast value $ depending upon which Forecast measure (revision) is picked. (measure below)
Somehow the measure above is not working and giving error
Can someone please help here
Thank you so much !!
Solved! Go to Solution.
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
Thank you so much for your help
It worked
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |