Forum Discussion
Post PatronCumulative totals getting split by year
Hi, GunnerJ ;
You could modify it:
TEST2 = CALCULATE ( COUNT ( 'Attrition Rate'[ACCT] ), FILTER ( ALL ( 'Attrition Rate' ), YEAR('Attrition Rate'[STARTDT])<=YEAR( MAX('Attrition Date'[Date]))&& 'Attrition Rate'[MINDISCDT] = DATEVALUE ( "1/1/1800" ) && 'Attrition Rate'[STARTDT] <> BLANK ()))And in last year ('2021') count is =8976
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Patronamitchandak
Here is the file. This is a test file so it's a bit unorganized. The visual in question is the "TEST by YearlyView" on the Filter Context Lost page. The measure is "TEST". I reviewed your post and beleive your active employees is in general what I'm trying to accomplish here. I'm not as familiar with some of the functions you used so I had a bit of difficulty following. I hope this file works and please let me know if you have any questions. Thank you for taking a look!
https://www.dropbox.com/s/8ssv0xw1p86hbin/Test%20Attrition%20File.pbix?dl=0
Post Patronamitchandak any chance the file I provided was something you could work with?