Calculate SUM of next level

[cblanton45]

My data set is fairly simple...I have a Level (FL) and Experience amount.  All I want to to do is calculate the SUM of Experience of the next level (e.g. If FL = 4, calculate the SUM of FL 5) .  In the visuals, a user needs to be able to select FL from a slicer and display the SUM of the next level.

[parry2k]

@cblanton45 try following DAX measure

Sum of Next Level = 
VAR __currentLevel = MAX( Table[FL] )
VAR __nextLevel = __currentLevel + 1
RETURN
CALCULATE(
SUM( Table[Experience]),
Table[FL] = __nextLevel
)

[cblanton45]

I believe the formula is working but issue is that when I select a FL from the slicer, it filters out the data needed to calculate this measure for the next level.  Is there some form of ALL I can insert that will honor the filter selection for calculating the measure?

[parry2k · Accepted solution]

@cblanton45 sorry missed that, add ALL() before Filter condition.

[cblanton45]

Thanks! This is the final formula I used that worked

Med Next Level = 
VAR __currentLevel = MAX( Sheet1[FL] )
VAR __nextLevel = __currentLevel + 1
RETURN
CALCULATE(
MEDIAN(Sheet1[Experience]),
FILTER(ALL(Sheet1),Sheet1[FL] = __nextLevel)
)