cax
1 TopicDAX measure calculate filter returning incorrect result
Hello DAX experts, Please refer the screenshot. I have a Measure name "CurYear" which equals 2024. When I use "CurYear" in another Measure "Act.YTD.CurrentYear", the CurYear is returning both 2023 and 2024 instead of only 2024. The result for 2024 Act. should be 3,106 but the measure is also summing year 2023 making the total to 14,764, which is not correct. My goal is to let [Fiscal Year] dynamically pick the result (i.e. 2024) from Measure "CurYear". Can someone please help fix this? Thank You!Solved1.3KViews0likes6Comments