Forum Discussion
Solved
help with drill through with cumulative total
I have a visual that shows the number of incidents over the year, with a line showing the accumulation for the year. When I drill through to show the data by week (or month, or year), however, ...
Okay, I got it to work by filtering other years and then using this:
CALCULATE(COUNTA('Table 1'[Date of Incident]),FILTER(ALL('Table 1'),ISONORAFTER('Table 1'[Date of Incident], MAX('Table 1'[Date of Incident]), DESC)))
It won't let me add the ".[YEAR]", it's grayed out when I try to type the formula suggested and it gives a message that a single value for variation [YEAR] for the column cannot be determined. I do have more than one year worth of dates in that column.
Okay, I got it to work by filtering other years and then using this:
CALCULATE(
COUNTA('Table 1'[Date of Incident]),
FILTER(
ALL('Table 1'),
ISONORAFTER('Table 1'[Date of Incident], MAX('Table 1'[Date of Incident]), DESC)
)
)
- Cmcmahan
Resident Rockstar
I'm glad you got it!
My original solution missed a right parens, so I added it back.
I'm curious which .[Year] it was giving you a hassle for. Was it the first or 2nd one?
