Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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 Thank you so much for your help. Now, I am getting better understanding about SelectedValue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |