DAX formula not accommodating legend/series variable

[Paul-NYS]

Hi Everyone
I have the below DAX formula that I am using for a pivot and chart that displays a cumulative percent of values over 6 month intervals--below is a link that has screenshots of the chart and pivot, slicers, etc. The StartYear variable is in the series/legend area of the pivot.

When I select just one year in the StartYear slicer, the pivot and chart display the correct values. However, when I select multiple years, it appears to add the values for the years together--see screenshots.

Does anyone know how to accommodate the legend variable in DAX so that its values are counted separately?

Paul

=(CALCULATE(countrows(s1Perm1),FILTER(ALLSELECTED(s1Perm1),s1Perm1[ExitMonthCategory] <= MAX(s1Perm1[exitMonthCategory]))))/(CALCULATE(COUNTROWS(s1Perm1),ALL(s1Perm1[Exit],s1Perm1[ExitMonthCategory])))


Link to screenshots:
http://www.nycourts.gov/surveys/cwcip/dax041714.zip

 

[Paul-NYS]

What I am trying to do is to find a DAX function that will not cumulate the 'startyear' variable that is in the Legend/Series in the pivot table. The below functions just cause the startyear values to cumulate all together (2006+2007+2008....) instead of treating the years as separate values:


=(CALCULATE(countrows(s1Perm1),FILTER(ALLSELECTED(s1Perm1),s1Perm1[ExitMonthCategory] <= MAX(s1Perm1[ExitMonthCategory]))))/(CALCULATE(COUNTROWS(s1Perm1),ALL(s1Perm1[Exit],s1Perm1[ExitMonthCategory])))