Bypass Page Level Filter for Single Visual/Measure

[djs25uk]

Dear All

I have a page level filter on Student[StudentYear] = 7. There is just one visual on the page that I would like to ignore this value, as I would like it to show the values for Student[StudentYear] = 8 instead. 

I have tried creating a measure that will SUM just the values where StudentYear is 8 but it is returning no results. I think it is still picking up the page level filter. Is there a way I can bypass the page level filter for one visual for sure?

DonationsPreviousYearGroup = CALCULATE(SUMX(FILTER('SchemePayment',RELATED(Student[StudentYear])=8),SchemePayment[SchemePaymentAmount]))

Many thanks for your help.

Daniel

[amitchandak · Accepted solution]

@djs25uk , Try like

	DonationsPreviousYearGroup = CALCULATE(SUMX('SchemePayment',SchemePayment[SchemePaymentAmount]), filter(all(Student),Student[StudentYear]=8))

[djs25uk]

Thank you so much! I tried using 'All' but clearly wasn't using in the right place. You're brilliant. 

Many thanks

Dan