Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Medida verdadera/falsa

Hola
Estoy tratando de crear una medida verdadera/falsa basada en un campo numérico y un campo de texto.
Si Número de unidades es 1 y el tipo de hallazgo es Embalaje mostrar 1, si no mostrar 0 etc...
Aquí es donde estoy en lo que va, pero la sintaxis es incorrecta
EP1 - IF(AND(SUM('Data'[Number of Units]-1),'Data'[Type of Find]-"Packaging"),1,0)
EP2 - IF(AND(SUM('Data'[Number of Units]-2),'Data'[Type of Find]-"Packaging"),1,0)
EP3 - IF(AND(SUM('Data'[Number of Units]>2),'Data'[Type of Find]-"Packaging"),1,0)
WL1 - IF(AND(SUM('Data'[Number of Units]-1),'Data'[Type of Find]"Location"),1,0)
WL2 á IF(AND(SUM('Data'[Number of Units]-2),'Data'[Type of Find]"Location"),1,0)
WL3 - IF(AND(SUM('Data'[Number of Units]>2),'Data'[Type of Find]"Location"),1,0)
Usaré las medidas en estados sobre un color visual a degradado basado en el valor, con diferentes colores para Embalaje y Ubicación.
Espero que tenga sentido que cualquier ayuda sea realmente apreciada.
1 ACCEPTED 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
  )

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@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
  )

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler

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
  )

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors