Forum Discussion

Gipardos's avatar
Gipardos
Frequent Visitor
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.