Forum Discussion
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...
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.
Still getting the same result.
Yes
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])
