When calculating previous FYTD i get the full year total

[paulsmith]

I have a table with records of calls to our company and it's linked directly to the dates table, that has dates from 2017 up until the end of this financial year (31/3/24)

When using this measure it in a chart it gives the correct information but when it's in a Card it gives the entire last financial years total.

Calls FYTD ly =  CALCULATE(  
     COUNT( Calls[Incident] ),    

     SAMEPERIODLASTYEAR( DATESYTD( DatesTable[CalDate] , "31/3")) 

) 

NB: The card has no filters and the chart as a filter to CalDate to show dates in this financial year.

To investigate i altered the measure to show the MIN & then the MAX date returned:

MIN comes back as 01/04/2022 which is correct 

MAX comes back as 31/3/2023 which is NOT correct (is should today - 1 year ie: 25/5/2022)

If i do a COUNT of the DatesTable[CalDate] (ie the number of days selected it returns 365 (a whole year).

In this graphic you can see the 14k in green is the total for last FY yet the same measure gives the correct data in the tooltip. 

Any help would be appreciated as this is really bugging me as to why it's selecting the whole year!

[Anonymous]

Hi @paulsmith ,

Normally card visual's row context should match with whole table, they may affect the time intelligence function usages.

I'd like to suggest you changed to use date function which support more complex customize to manually define the calculation ranges.

Time Intelligence "The Hard Way" (TITHW)  

Regards,
Xiaoxin Sheng