Forum Discussion
Running total not giving correct answer
hello Devon-Yeager
if i am not misunderstood the discussion, the problem is how to calculate running sum from a measure.
next the [Available Hours] is a form of measure from another calculation.
please check if this accomodate your expected result (please ignore the index as it works only as sorting in table visual).
i think the [5. Running Sum] above should be matched to your correct hours.
create a new measure for calculating Running Sum
5. Running Sum =
SUMX(
FILTER(
ALL('Table'),
'Table'[Date]<=MAX('Table'[Date])
),
[Available Hours]
)i made the [Available Hours] above as a measure because your original data has [Available Hours] as measure.i assumed you have expected result for calculations before [Available Hours].Hope this will help.Thank you.
I do not want to see the expected result of the running total - the formula which i shared with you previously will defenitely work. I want to see the expected result of the What-If employee count measure - the one which you think is failing.
Maybe my additional comment I left earlier this week that includes the What If Employee Count and 3 other columns could be helpful. If not, I understand. Thanks.