Forum Discussion
Analisis comparativo
Hola,
Tengo una consulta sobre como generar un analisis de comparacion.
Se tiene una tabla resumen donde se obtiene los numeros de produccion de cierto material, y se quiere comparar con el total de estimacion que nace de un resumen de otra tabla.
De la tabla grande, estan todos los detalles de produccion que se quiere comparar con el total de estimación.
¿Como se puede realizar?
Modelo
EstimacionesEjemplo
Hi, Gipardos
Based your information, I create a table
Create two measures, you can try these DAX:
Difference = CALCULATE(SUM('Table'[Real])-SUM('Table'[Estimate]),'Table'[Region]='Table'[Region] )Difference total = CALCULATE(SUM('Table'[Estimate total]) - SUM('Table'[Real]),'Table'[Region]='Table'[Region])Put them in the table view, here is my preview:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, Gipardos
Based your information, I create a table
Create two measures, you can try these DAX:
Difference = CALCULATE(SUM('Table'[Real])-SUM('Table'[Estimate]),'Table'[Region]='Table'[Region] )Difference total = CALCULATE(SUM('Table'[Estimate total]) - SUM('Table'[Real]),'Table'[Region]='Table'[Region])Put them in the table view, here is my preview:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you,
Your help helped me
