I am trying to make a cumulative sum column that calculates the cumulative sum based off of an employees name, and the year. So Alice and Bob may have values for 2020 and 2021 that I would like to calculate seperately. Right now my formula is
TotalByMonth running total in Period|Year|Director =
ALLSELECTED('Table'[Year|Employee], 'Table'[Employee], 'Table'[Year]),
ISONORAFTER('Table'[Year|Director], MAX('Table'[Year|Employee]), DESC)
But the issue I am having is that slicers do not seem to impact the year, only the Employee name.