Forum Discussion
Post ProdigyHow 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:
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.
4 Replies
- wdx223_Daniel
Community Champion
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
