Forum Discussion
Post ProdigySumX? - cumulative running total
lbendlin Ashish_Mathur v-prasare
Guess what - think I got the problematic measure to work :). I remain confused in many areas of DAX - but I can move forward now. Thank you to all three of you for your suggestions.
My solution was to place Animal Days in a SumX iterator - and that resulted in the group total work, as well as the cumulative animal day measure. Something simple, but yet so confusing.
=Var ReportValue = SUMX(VALUES('Calendar'[Dates]),[End Animal Inventory Quantity]) return ReportValue
Super UserToo may tabs and too many measures creating more confusion than clarity. Share a much smaller dataset with only the information which is necessary. Show the expected result and calculation logic there.
Post Prodigy
Hello, I've attempted to cleanup/simplify the spreadsheet to only relevant measures. I have moved all the required measures to a _measures table. The hilighted measures are related to the problematice Animal Day calculation.
Below is the excel pivot table I am working with. Column I (in green) is my desired result for Column F (cumulative animal days). The measures relating to "Feed Fed" are working as expected - with equivalent DAX pattern for Animal Days Cumulative.
And just to be safe - including a new link.
https://drive.google.com/drive/folders/1-dKYRdtfqyVYNsHLCZrLO_v08gaUFruI?usp=drive_link
I do appreciate your help - and apologize for not being clear and concise in my communications.
thank you!