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.