Forum Discussion
Solved
Ignore Row Context in Measure
I am trying to return the maximum catalog date based on a certain slicer, but ignoring all other filters and row context. I am using the below measure: most recent test = CALCULATE(MAX('Catalog D...
HI khappersett
I think you need to clear the filter context on the Wholesale ID field. Try adding that field to your ALLEXCEPT function as a third parameter.
HI khappersett
I think you need to clear the filter context on the Wholesale ID field. Try adding that field to your ALLEXCEPT function as a third parameter.
Thank you so much!!!!! That worked! This is the code I used:
most recent test = CALCULATE(MAX('Catalog Detail'[Release Date]), ALLEXCEPT('Catalog Detail','Catalog Detail'[Common Catalog Name]), ALL('Account Detail'))Cool. Is 'Account Detail' the same field as 'Wholesale ID' ?