sum of several measurements in a single column with 9 values, Power BI

[yaguaso]

Hello community. I am trying to show the sum of several measurements in a single column with 9 values,

but it gives me an error that says: Mdxscript(Model) (385.9) Calculation error in measure 'CALCULOS' [MOSTRAR actividades]: A multi-value table was provided where a single value was expected.

The formula entered is:

Mostrar Actividades =

    SWITCH (VALUES(ACTIVIDADES[POSICION]),

        1, [A1 Variable],

        2, [A2 Variable],

        3, [A3 Variable],

        4, [A4 Variable],

        5, [A5 Variable],

        6, [A6 Variable],

        7, [A7 Variable],

        8, [A8 Variable],

        9, [A9 Variable],

    15

)

Could someone help me determine what is wrong?

[yaguaso · Accepted solution]

Thanks for the help, but solved the problem using the following measurement:

MOSTRAR_ACTIV =

 IF(HASONEVALUE(ACTIVIDADES[POSICION]),

SWITCH(VALUES(ACTIVIDADES[POSICION]),

 1, [A1 Variable],

 2, [A2 Variable],

 3, [A3 Variable],

 4, [A4 Variable],

 5, [A5 Variable],

 6, [A6 Variable],

 7, [A7 Variable],

 8, [A8 Variable],

 9, [A9 Variable],

 10

 ))

[Anonymous]

Hi @yaguaso ,

You can update the formula of measure [Mostrar Actividades] as below and check if it can return the expected result...

Mostrar Actividades =
SWITCH (
    SELECTEDVALUE ( ACTIVIDADES[POSICION] ),
    1, [A1 Variable],
    2, [A2 Variable],
    3, [A3 Variable],
    4, [A4 Variable],
    5, [A5 Variable],
    6, [A6 Variable],
    7, [A7 Variable],
    8, [A8 Variable],
    9, [A9 Variable],
    15
)

Best Regards