Forum Discussion
Same measure 2 different values
Thank you for replying.
The issue was a 'human error' incident - someone had entered a future Resolution date (29/07/2025) and that screwed everything up - my 24/25 FY ends 31st March and Jul 2025 is FY 25/26
Hi ArchStanton ,
if it worked yesterday and now returns 1, something in your data, filters, or model might have changed.
try to double check your slicers, filter pane and so on.
Its complicated to say what is happening whitout the sample data.
or try to filter like this to debbug:
YTD Closed Cases 3 = CALCULATE(
TOTALYTD(COUNT('Cases'[Case Number]),
'Cases'[Resolution Date],"31/03"),
FILTER(ALL('Cases'), 'Cases'[statecode] = "Resolved")
)
Thank you for replying.
The issue was a 'human error' incident - someone had entered a future Resolution date (29/07/2025) and that screwed everything up - my 24/25 FY ends 31st March and Jul 2025 is FY 25/26
Hi ArchStanton ,
Happy you find the problem, please consider to accept the relevant reply as solution to close the tread.
Thank you