Forum Discussion

Rena's avatar
Rena
Resolver II
1 year ago
Solved

Total Not Actually Adding - already using SUMX/VALUES

Here is my problem.  I am trying to get an estimated annualized number.  I have the YTD Volume, and the Volume Remaining for the rest of the year.  Dividing these gives me the volume factor (so I can...
Need Help
  • Rena's avatar
    Rena
    1 year ago

    I probably did this the longest way possible, but it works!  I went through and created a new table that simply had the plant name in one column.  Then I added 3 columns - Volume YTD using the same formula I had for measure, Volume Remaining using the same formula as the measure, and Volume Factor using the same formula for the measure I already had.

     

    Then I changed my measure to this and it worked.

     

     

     

Rena's avatar
Rena
Resolver II
1 year ago

Still getting the same result.

 

 

  • hnguy71's avatar
    hnguy71
    Super User
    1 year ago

    Hi Rena 

    I see plant as the row in your visual, is that the same field name?

  • Rena's avatar
    Rena
    Resolver II
    1 year ago

    Yes 

     

    • hnguy71's avatar
      hnguy71
      Super User
      1 year ago

      Okay, let's try a different method...

      VA PO SFG Yield Loss Test =

VAR _Tbl = SUMMARIZE(Yield_List, Yield_Loss[_BIC_ZAGGRESC], "@Value", [VA PO SFG Yield Loss $])
RETURN
SUMX(_Tbl, [@Value])

       

      • Rena's avatar
        Rena
        Resolver II
        1 year ago

        No luck... 

        I really appreciate the effort.  I am at a complete loss as to why this one won't work.