Forum Discussion
Filtered Accumulation in DAX
Hey guys! Here's my data model. All columns are text, except "Datas":
"Semana/Ano" means "Week/Year". "Datas" mean "Dates". Both reports are connected by "Dates". I used your tips and got two different results:
The "Year" slicer functions correctly on both charts.
However, the other slicers only work on the top chart, which displays non-cumulative data. In both charts, the bars represent actual results, while the line indicates the target.My database originally had each "Event" as separate columns with corresponding dates. I’ve unpivoted the data into Events and Datas.
Hi, thanks for your reply!
It almost worked. When I use a slicer, the weeks are no longer hidden — which is great. However, the values are no longer accumulating over time.
Solution SageСould you share an example report (while avoiding confidential data, of course) to better understand your issue?