Forum Discussion
Solved
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 tot...
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