Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Logistica_BI
Frequent Visitor

¿Como puedo hacer que el total de una medida, me sume todos los datos de dicha medida?

hola buen dia

 

agradeceria su ayuda con este caso:

estoy calculando una medida "Conf Inv Lote-Pond", multiplicando dos medidas antes echas (confiabilidad de lote * peso%) pero en el TOTAL de la medida aplica el mismo cálculo de la medida y lo que necesito que me muestre en el TOTAL: es la suma de cada dato obtenido por centro y almacen, dejo tabla para entender lo antes dicho, mil gracias si me ayudan.

 

en ves de dar 80,45% deberia dar 74% aproximadamente (Resultado en letra verde)

centroalmacenconfiabilidad de lotepeso%Conf Inv Lote-Pond
cd01DS01100%0%0%
cd01EX02100%0,58%0,58%
cd01MQ01100%0,01%0,01%
cd01PT0273,71%98,98%72,96%
Cd01RE01100%0,42%0,42%
Total 80,46%99,9%80,45%

muchas gracias

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi @Logistica_BI 

This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

For your case, Just use this formula to create a new measure:

Measure= VAR _TABLE=SUMMARIZE( Table, Table[centro],Table[almacen], "_value",[Conf Inv Lote-Pond]) return

SUMX(_TABLE, [_Value])

 

or just adjust the Conf Inv Lote-Pond measure as below:

Conf Inv Lote-Pond= VAR _TABLE=SUMMARIZE( Table, Table[centro],Table[almacen], "_value",[confiabilidad de lote]*[peso%]) return

SUMX(_TABLE, [_Value])

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi @Logistica_BI 

This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

For your case, Just use this formula to create a new measure:

Measure= VAR _TABLE=SUMMARIZE( Table, Table[centro],Table[almacen], "_value",[Conf Inv Lote-Pond]) return

SUMX(_TABLE, [_Value])

 

or just adjust the Conf Inv Lote-Pond measure as below:

Conf Inv Lote-Pond= VAR _TABLE=SUMMARIZE( Table, Table[centro],Table[almacen], "_value",[confiabilidad de lote]*[peso%]) return

SUMX(_TABLE, [_Value])

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PaulDBrown
Community Champion
Community Champion

@Logistica_BI 

 

Asumiendo que la tabla de donde proceden las columnas de centro y almacen se llama "Tabla", prueba con esta medida:

Conf Inv Lota-pond con totales = SUMX(Tabla, [confiabilidad de lote] * [peso%])

A ver si es lomque necesitas

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.