Forum Discussion
Total Not Actually Adding - already using SUMX/VALUES
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.
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])
No luck...
I really appreciate the effort. I am at a complete loss as to why this one won't work.
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.
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.