Forum Discussion

djs25uk's avatar
djs25uk
Helper I
6 years ago
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[Studen...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    djs25uk , Try like

    	DonationsPreviousYearGroup = CALCULATE(SUMX('SchemePayment',SchemePayment[SchemePaymentAmount]), filter(all(Student),Student[StudentYear]=8))
amitchandak's avatar
amitchandak
Super User
6 years ago

djs25uk , Try like

	DonationsPreviousYearGroup = CALCULATE(SUMX('SchemePayment',SchemePayment[SchemePaymentAmount]), filter(all(Student),Student[StudentYear]=8))
  • djs25uk's avatar
    djs25uk
    Helper I
    6 years ago

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

    Many thanks

    Dan