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
ArchStanton Well, it's possible that a refresh partially failed I suppose. Is this an import model with nightly refreshes? If so, I would first start with checking your tables to see if all the data is there that should be.
Failing that, I would recode your DAX measure so that you can actually troubleshoot what is going on, maybe something like:
YTD Closed Cases 4 =
VAR __Today = TODAY()
VAR __MinDate = DATE( YEAR( __Today ) - 1, 3, 31 )
VAR __Table = FILTER( 'Cases', [statecode] = "Resolved" && [Resolution Date] > __MinDate )
VAR __Result = COUNTROWS( __Table )
RETURN
__ResultThank you for the troubleshooting example, its something I'm going to refer to in future.
This current issue however turned out to be 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