Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JustinDoh1
Post Prodigy
Post Prodigy

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors