Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
@rm19 - Prueba:
EP1 =
IF(
AND(
SUM('Data'[Number of Units])=1,
MAX('Data'[Type of Find])="Packaging"
)
,1,0
)
O
EP1 =
IF(
SUM('Data'[Number of Units])=1 &&
MAX('Data'[Type of Find])="Packaging"
,1,0
)
@rm19 Parece que esto debería ser:
EP1 =
IF(
AND(
SUM('Data'[Number of Units]=1),
MAX('Data'[Type of Find])="Packaging"
)
,1,0
)
O
EP1 =
IF(
SUM('Data'[Number of Units]=1) &&
MAX('Data'[Type of Find]="Packaging")
,1,0
)
Gracias por responder, desgraciadamente el error: La función SUM sólo acepta una referencia de columna como argumento. ha llegado a ambas opciones.
'Datos'[Número de unidades] es un campo numérico,
'Data'[Type of Find]-"Packaging" es un campo de texto.
@rm19 - Prueba:
EP1 =
IF(
AND(
SUM('Data'[Number of Units])=1,
MAX('Data'[Type of Find])="Packaging"
)
,1,0
)
O
EP1 =
IF(
SUM('Data'[Number of Units])=1 &&
MAX('Data'[Type of Find])="Packaging"
,1,0
)