Filter not Working

Hi newhopepdx,

Since the previous approaches are not working properly, let's use a measure that dynamically filters the transactions:

SPLY Row Filter = VAR __minDate = MIN('Date'[Date])

VAR __maxDate = MAX('Date'[Date])

VAR __startDate = DATE(YEAR(__minDate) - 1, MONTH(__minDate), DAY(__minDate))

VAR __endDate = DATE(YEAR(__maxDate) - 1, MONTH(__maxDate), DAY(__maxDate))

RETURN

IF(SELECTEDVALUE('FinancialTrans'[TransactionDate]) >= __startDate &&

    SELECTEDVALUE('FinancialTrans'[TransactionDate]) <= __endDate,

    1,

    0

)

Use the FinancialTrans as the table visual’s data source. Add the SPLY Row Filter measure to the table visual and apply a visual-level filter i.e set SPLY Row Filter = 1 , this ensures only transactions in the SPLY range are shown.

This will avoid extra tables or slicers and dynamically filters the data correctly.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa