The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
Thanks for the help, but solved the problem using the following measurement:
Thanks for the help, but solved the problem using the following measurement:
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