Forum Discussion

WinterMist's avatar
WinterMist
Impactful Individual
3 years ago

Excluding Future Years from DAX Code

Hello,   Measure 7.1.3.1 correctly calculates the number of New Agents for each year in the Line Chart. The only problem is that it includes future year 2024. (This also causes the card to incorr...
Wilson_'s avatar
Wilson_
Memorable Member
3 years ago

Hey Nathan,

 

I believe if you just returned Result in measure 7.1.3.1, 2024 would not show up in the first visual.

 

Also, I believe 7.1.3.2 is breaking because no matter where you are on the x-axis, you're now overriding the filter on policy year with a filter that looks at all policy years 2023 and back. More concretely, no matter what year you look at on the x-axis, what the calculate in 7.1.3.2 is doing is returning all data from 2011 to 2023 instead of just that one year. Therefore, CY is always 2023 and PY is always 2022. That's why the second visual always returns 14, which is the calculation for 2023 in the first visual.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)