Forum Discussion
DAX: Cumulative Total Applying filters
Hi, I was trying to get the cumulative total from a filtered dataset selecting some years in the slicer, but I'm always obtaining the cumulative from the whole dataset only for the selected years...
Greg_Deckler
Community Champion
Community ChampionIs "Total" a column in your example a column? The default SUM aggregation of the column will work in your case for the data you provided.
"Total" is a measure, a simple of a sum of a column. The problem is the cumulative is always taking the previous years, ignoring the slicer. Please find a link of PBIX file where I have reproduced my problem:
https://www.dropbox.com/s/rurt5vp7ddbcs87/Test%20Cumulative%20Total%20Applying%20filters.pbix?dl=0
Thanks.