Solved: Ayudar a calcular con 2 condiciones

Anonymous · ‎04-17-2020

Quiero calcular con 2 condiciones:

Ejemplo: calcular si la persona asistió a sí, y la persona proporcionó comentarios - Sí

calculate(totalattendees), attendees[attended] - 'Yes' & attendees[feedback] - 'Yes'

no está seguro de cómo configurar este cálculo, nuevo en estos cálculos 🙂 gracias por la ayuda de antemano!

Greg_Deckler · ‎04-17-2020

calculate([totalattendees], FILTER('attendees', attendees[attended] - "Yes" && attendees[feedback] - "Yes"))

Si [totalattendees] es una medida, de lo contrario, tal vez.

COUNTROWS(FILTER('attendees', attendees[attended] - "Yes" && attendees[feedback] - "Yes"))

@ 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!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎04-17-2020

calculate([totalattendees], FILTER('attendees', attendees[attended] - "Yes" && attendees[feedback] - "Yes"))

Si [totalattendees] es una medida, de lo contrario, tal vez.

COUNTROWS(FILTER('attendees', attendees[attended] - "Yes" && attendees[feedback] - "Yes"))

@ 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!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Ayudar a calcular con 2 condiciones

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024