Forum Discussion
Solved
Bypass Page Level Filter for Single Visual/Measure
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
djs25uk , Try like
DonationsPreviousYearGroup = CALCULATE(SUMX('SchemePayment',SchemePayment[SchemePaymentAmount]), filter(all(Student),Student[StudentYear]=8))
2 Replies
djs25uk , Try like
DonationsPreviousYearGroup = CALCULATE(SUMX('SchemePayment',SchemePayment[SchemePaymentAmount]), filter(all(Student),Student[StudentYear]=8))Thank you so much! I tried using 'All' but clearly wasn't using in the right place. You're brilliant.
Many thanks
Dan
