cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JustinDoh1
Post Patron
Post Patron

How to fix Age Band gap (calculated column)

I am sharing my Pbix file at this Google drive.

 

I have created a calculated column like below:

JustinDoh1_0-1626888029719.png

 

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):

 

JustinDoh1_1-1626888414741.png

 

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

 

Thanks.

 

 

1 ACCEPTED SOLUTION

4 REPLIES 4
wdx223_Daniel
Super User
Super User

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.

@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_0-1626913676541.png

 

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

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors