SUMAR TOTALES 2 Custom Tables

[romovaro]

Buenas tardes,

Tengo una tabla general llamada "BPMS LOF Report". De ella he creado 2 "custom tables"

"simplemente lo que necesito es conseguir sumar el total de CUID de las 2 tablas pero tengo problemas...

En este caso seria 819 + 212.

Gracias

Booked by Pre Eng Team table:

Booked by Pre Eng Team =

VAR MeetsFirstRequirement =

CALCULATETABLE(

VALUES( 'BPMS LOF Report'[CUID] ),

CONTAINSSTRING(

'BPMS LOF Report'[TASK],

"Start Partner Engagement"

)

&& 'BPMS LOF Report'[TASKACTUALPERFORMER] = "Will Smith"

|| 'BPMS LOF Report'[TASKACTUALPERFORMER] = "John SMith"

|| 'BPMS LOF Report'[TASKACTUALPERFORMER] = "Juan Fernandez"

)

VAR MeetsBothRequirements =

CALCULATETABLE(

VALUES( 'BPMS LOF Report'[CUID] ),

MeetsFirstRequirement,

'BPMS LOF Report'[TASK_STATUS] = "Closed",

CONTAINSSTRING(

'BPMS LOF Report'[TASK],

"Partner Acknowledgement"

)

)

VAR Result =

ADDCOLUMNS (

MeetsBothRequirements,

"Date Closed",

CALCULATE (

MAX ( 'BPMS LOF Report'[Task Completed]),

'BPMS LOF Report'[TASK_STATUS] = "Closed",

CONTAINSSTRING (

'BPMS LOF Report'[TASK],

"Partner Acknowledgement"

)

)

)

RETURN

Result

I otra tabla

To be confirmed Pre Eng Team

To be Confirmed Pre Eng Team =

VAR MeetsFirstRequirement =

CALCULATETABLE(

VALUES( 'BPMS LOF Report'[CUID] ),

CONTAINSSTRING(

'BPMS LOF Report'[TASK],

"Start Partner Engagement"

)

&& 'BPMS LOF Report'[TASKACTUALPERFORMER] = "Will Smith"

|| 'BPMS LOF Report'[TASKACTUALPERFORMER] = "John SMith"

|| 'BPMS LOF Report'[TASKACTUALPERFORMER] = "Juan Fernandez"

)

VAR MeetsBothRequirements =

CALCULATETABLE(

VALUES( 'BPMS LOF Report'[CUID] ),

MeetsFirstRequirement,

'BPMS LOF Report'[TASK_STATUS] = "Received",

CONTAINSSTRING(

'BPMS LOF Report'[TASK],

"Partner Acknowledgement"

)

)

VAR Result =

ADDCOLUMNS (

MeetsBothRequirements,

"Date Closed",

CALCULATE (

MAX ( 'BPMS LOF Report'[Task Completed]),

'BPMS LOF Report'[TASK_STATUS] = "Received",

CONTAINSSTRING (

'BPMS LOF Report'[TASK],

"Partner Acknowledgement"

)

)

)

RETURN

Result

[Syndicate_Admin · Accepted solution]

¿ @Syndicate_Admin

¿Utiliza la agregación de recuento en columnas CUID para obtener el 819 y el 212? Si es así, puede crear una medida para agregar ambos.

Total CUID = COUNT('Booked by Pre Eng Team'[CUID]) + COUNT('To be Confirmed Pre Eng Team'[CUID])

Ponga la medida anterior en una tarjeta visual. Obtendrá el valor total.

Saludos
Equipo de soporte de la comunidad _ Jing
Si esta publicación ayuda, por favor acéptala como Solución para ayudar a otros miembros a encontrarla.