Disable specific filter on tooltip chart

Hi harshadrokade,

I think you need to change your tooltip report page DAX expression to add 'all' functions to ignore the current filter and add variables to store and calculate the previous date period.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Then you can use this variable as a condition to calculate corresponding results.

formual =
VAR currDate =
    MAX ( Table[Date] )
VAR prevDate =
    DATE ( YEAR ( currDate ) - 1, MONTH ( currDate ), DAY ( currDate ) )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER ( ALL ( Table ), [Date] = prevDate ),
        VALUES ( Table[Student name] ),
        VALUES ( Table[Subject name] )
    )

Regards,

Xiaoxin Sheng