Forum Discussion

Abevann's avatar
Abevann
Icon for Helper III rankHelper III
4 years ago
Solved

Total in bar graph and table is wrong

Guys, I have an issue with one customer. The problem is in a graph; I have 3 columns with sales from previous year, Sales and Sales target. Everything seems to be fine when I configure it up the pre...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try this measure:

    Previous Year =
SUMX (
    'Fecha table',
    CALCULATE ( [Sum Venta], DATEADD ( 'Fecha table'[Date], -1, YEAR ) )
)
Abevann's avatar
Abevann
Icon for Helper III rankHelper III
4 years ago

Hey Paul,

I marked as data table and lost the hierarchy; then I did my own using Fecha as a hierarchy “root”, and manually add year, month, and day, but the results were exact same thing; in the daily view, the day shows the correct amount, and same thing than the table but once I build my own hierarchy and show monthly results, I got the wrong result.

 

 

 

 

 

 

Besides that, even if I don’t use hierarchy, only “Fecha” (marked as date Table), got same wrong result $5,564,885.04 instead of $1,731,496.46:

 

 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Can you share some sample data (non-confidential) please?

  • Abevann's avatar
    Abevann
    Icon for Helper III rankHelper III
    4 years ago

    Sure, I'll clean up the data and then send it, thanks

     

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Try this measure:

      Previous Year =
SUMX (
    'Fecha table',
    CALCULATE ( [Sum Venta], DATEADD ( 'Fecha table'[Date], -1, YEAR ) )
)
      • Abevann's avatar
        Abevann
        Icon for Helper III rankHelper III
        4 years ago

        I will and let you know, thanks