Forum Discussion

ChristophEmrich's avatar
ChristophEmrich
Frequent Visitor
7 years ago
Solved

SELECTEDVALUE seemingly does not work

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 ...
  • v-lili6-msft's avatar
    7 years ago

    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