I have a DAX to calculate cumulative total. it is giving correct result if there are no filters or slicers applied. I have year slicer, when I click on that, 2019 year gives me correct result for every month but when I click 2018, it is giving me same result for every month. I have only data from September to December for 2018.
Cumulative District Logins = IF([Total District Logins]= 0, BLANK(), CALCULATE([Total District Logins] , FILTER(ALLSELECTED(Ed360Usage[Logged in date].[Date]), Ed360Usage[Logged in date].[Date]<=MAX(Ed360Usage[Logged in date].[Date]))) )
I do not have date table. I did try using data table but Date table would not connect properly to my fact table. None of the fact table dates matching my Date table. I’m not able to figure out why: