topic Re: sum of several measurements in a single column with 9 values, Power BI in DAX Commands and Tips

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

yaguaso — Thu, 11 Jan 2024 14:16:37 GMT

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],

)

Could someone help me determine what is wrong?

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

Anonymous — Fri, 12 Jan 2024 03:17:06 GMT

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

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

yaguaso — Wed, 24 Jan 2024 19:39:06 GMT

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

MOSTRAR_ACTIV =

IF(HASONEVALUE(ACTIVIDADES[POSICION]),

SWITCH(VALUES(ACTIVIDADES[POSICION]),