Forum Discussion
Solved
suma de medida
buen dia me gustaria su apoyo para obtener la suma del totalizado de la tabla: cuento con las columnas: servicio, tag, acumulado, fecha, dia cree un media : TOTALIZADO DIARIO PRINCIPAL1 el cual...
Hi davidprograma ,
This may work:
TOTAL DIA CONSUMO = VAR t_ = ADDCOLUMNS ( SUMMARIZE ( ALLSELECTED ( tabla1 ), [SERVICIO], [TAG], [DIA] ), "TOTALIZADO DIARIO PRINCIPAL1_", [TOTALIZADO DIARIO PRINCIPAL1] ) RETURN SUMX ( t_, [TOTALIZADO DIARIO PRINCIPAL1_] )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
si funciono con esta solucion mucas gracias por el apoyo
no funciono y me arrojo otros datos:
| SERVICIO | TAG | DIA | TOTALIZADO DIARIO PRINCIPAL1 | TOTA DIA CONSUMIDO | ULTIMA FECHA PRINCIPALES3 |
| Agua | FIT0600 | 28 | 198.78 | 1117.8 | 28/03/2022 23:59 |
| Agua | FIT0600 | 29 | 314.06 | 1117.8 | 29/03/2022 23:59 |
| Agua | FIT0600 | 30 | 313.15 | 1117.8 | 30/03/2022 23:58 |
| Agua | FIT0600 | 31 | 291.81 | 1117.8 | 31/03/2022 23:59 |
| Agua | FIT0613 | 28 | 124.19 | 776.41 | 28/03/2022 23:59 |
| Agua | FIT0613 | 29 | 220.99 | 776.41 | 29/03/2022 23:58 |
| Agua | FIT0613 | 30 | 217.18 | 776.41 | 30/03/2022 23:59 |
| Agua | FIT0613 | 31 | 214.05 | 776.41 | 31/03/2022 23:59 |
Icey
Community Support
Community SupportHi davidprograma ,
This may work:
TOTAL DIA CONSUMO =
VAR t_ =
ADDCOLUMNS (
SUMMARIZE ( ALLSELECTED ( tabla1 ), [SERVICIO], [TAG], [DIA] ),
"TOTALIZADO DIARIO PRINCIPAL1_", [TOTALIZADO DIARIO PRINCIPAL1]
)
RETURN
SUMX ( t_, [TOTALIZADO DIARIO PRINCIPAL1_] )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.