Total Not Actually Adding - already using SUMX/VALUES

[Rena]

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 take YTD actuals * the volume factor) to get an annualized number.  Everything works until the totals column.  Instead of summing the Volume Adjusted Yield Loss, it is multiplying the Total Yield Loss * the average volume factor.  

The total for the last column should be $4,106,751 (the sum of the three numbers in the column) but instead it is taking $1,389,422 (total yield loss for the 3 plants) * 2.908 (average volume factor) and only returning a value of $4,040,439.

@TheoC 

@FreemanZ 

[Rena]

Still getting the same result.

[Rena]

Yes 

[hnguy71]

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]

No luck... 

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

[hnguy71]

Do you have sample data that you can share that I can recreate on my end? If you can anonymize the data and share that would be great.

[Rena · Accepted solution]

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.

[hnguy71]

Hi @Rena 

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

[hnguy71]

Hi @Rena 

You can accomplish it by splitting it into two measures:

First measure is your normal calculation:

CALCULATE( SUM(YieldLoss[_BIC_Z_YLD_LSA]), FITLER_CRITERIA )

Then use the SUMX separately:

Corrected Totals = 
SUMX( VALUES(BIC_ZAGGRESC), [VA_PO_SFG_Yield_Loss_TEST])