Forum Discussion

Cramos's avatar
Cramos
Frequent Visitor
9 years ago
Solved

Sum Total vs a single value

Hi,   I'm stuck with something very silly but I'cant find the solution.   I have the sales for the month and a target for each month.    Something like this:   Table 1   MONTH Target ...
Need Help
  • hohlick's avatar
    hohlick
    9 years ago

    Your tables have to be linked someway, for example, by month (Table1 to Table 2, 1 to many)

     

    Then a new measure:

    Sales diff = CALCULATE(SUM('Table 2'[Sales]))-CALCULATE(SUM('Table 1'[Target]))

     

    Then you'll get desired amount for all months or for selected month only.

    For example, if you make a bar chart visual with month number as x-axis, and put this measure in the values, you'll get what you want

hohlick's avatar
hohlick
Continued Contributor
9 years ago

Are the months have different names in your tables? "Ene" and "January"?

  • Cramos's avatar
    Cramos
    Frequent Visitor
    9 years ago

    Always the same, in fact i'm using the number of the month

    • hohlick's avatar
      hohlick
      Continued Contributor
      9 years ago

      Your tables have to be linked someway, for example, by month (Table1 to Table 2, 1 to many)

       

      Then a new measure:

      Sales diff = CALCULATE(SUM('Table 2'[Sales]))-CALCULATE(SUM('Table 1'[Target]))

       

      Then you'll get desired amount for all months or for selected month only.

      For example, if you make a bar chart visual with month number as x-axis, and put this measure in the values, you'll get what you want

      • Cramos's avatar
        Cramos
        Frequent Visitor
        9 years ago

        Works perfectly! Thank you so much!!