Forum Discussion
suma de medida
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
Community SupportHi davidprograma ,
How about this?
TOTAL DIA CONSUMO =
SUMX ( ALLSELECTED ( tabla1[dia] ), [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.
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 |
me explico con la medida-> TOTALIZADO DIARIO PRINCIPAL1 obtengo de la columnan acumulado el valor mas alto con respecto a cada dia transcurido y es el valor que muestro en la tabla y solo quiero sumar esos datos por medio de otra medida
- Icey
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.