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 ) )
)
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

 Does the 'Fecha' table contain continuous dates covering the whole range of dates in the model?

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

    Correct, Fecha is continuos and based in the table formula:  

    Fecha = CALENDAR(MIN(Comercializar[DocDate]), MAX(Comercializar[DocDate]))
     
    And choosing the "Show items with no data" option, it shows empty spaces for 1, 2 and so on and so forth...:

     

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

      It looks like you are using fields from an automatic date hierarchy. You should be using the fields from the Fecha table (which btw you should mark as the date table if you haven't)

      • 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: