How to fix Age Band gap (calculated column)

[JustinDoh1]

I am sharing my Pbix file at this Google drive.

I have created a calculated column like below:

The issue is when person reaches at the age on 55(on the bottom example (or in the Pbix file)), AgeBandMeasure shows blank (as below):

How to go about fixing the DAX here on "Age Band" or is there other area that needs to be fixed?

Thanks.

[wdx223_Daniel]

this is not about the formula of calculated column and measure.

it's the problem of selectedvalue, in Feb 2020,there are two different agebands, 50-65 and 65-70. then selectedvalue will get the blank value.

[JustinDoh1]

@wdx223_Daniel  Thank you for your comment.

How do I fix the issue of certain age applying to two age bands intead of one?

Should't it be fixed at the "Age Band" calculated column?

For this example, I would like 55-64 as Age Band for May 2020 (where there is a blank value).

BTW, I updated the Pbix file as well as original content since Age Band has been modified (also with different scenario (age 55)). 

[wdx223_Daniel · Accepted solution]

[JustinDoh1]

@wdx223_Daniel Thank you so much for your help. Now, I am getting better understanding about SelectedValue.