March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi everybody,
I'm probably doing something because I cannot get SELECTEDVALUE to work.
I have two columns: "CURRENT PLAN" and "PLAN". Both columns have 3 different values: "Plan 2018", "Plan 2019" and "Plan 2020".
I'd like to add a slicer for "CURRENT PLAN" and with that slicer only one option of the three can be selected. Then I have a measure displaying the units of that selected plan. The measure formula looks like this:
Current Plan Units = VAR SlicerValue = SELECTEDVALUE('Table Plans'[CURRENT PLAN]) RETURN SUMX(FILTER('Table Plans','Table Plans'[PLAN]=SlicerValue),'Table Plans'[Units])/1000
SELECTEDVALUE seems to always go the FALSE route. I don't know why...
Thank you already!
Christoph
Solved! Go to Solution.
hi, @ChristophEmrich
First, for SELECTEDVALUE,
SELECTEDVALUE(<columnName>[, <alternateResult>])
Term | Definition |
---|---|
columnName | The name of an existing column, using standard DAX syntax. It cannot be an expression. |
alternateResult | (Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK(). |
You couldn't select more than one value in slicer.
Second, from your formula we know that all the column are in the same table, if there is something wrong in here.
If you still have the problem, please share some sample data and your expected output.
Best Regards,
Lin
I don't know who selected the reply as solution, it wasn't me. It still does not work.
hi, @ChristophEmrich
First, for SELECTEDVALUE,
SELECTEDVALUE(<columnName>[, <alternateResult>])
Term | Definition |
---|---|
columnName | The name of an existing column, using standard DAX syntax. It cannot be an expression. |
alternateResult | (Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK(). |
You couldn't select more than one value in slicer.
Second, from your formula we know that all the column are in the same table, if there is something wrong in here.
If you still have the problem, please share some sample data and your expected output.
Best Regards,
Lin
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |