Ignore Row Context in Measure

[khappersett]

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 Detail'[Release Date]), ALLEXCEPT('Catalog Detail','Catalog Detail'[Common Catalog Name]))

I have a Common Catalog Name selected in my slicer and you can see the possible release dates below, but in my table I am still returning 6/3/2016 for some rows. I want them to all say 6/2/2017. I believe this is because the wholesale IDs only bought items in the earlier catalog release, but I thought the ALLEXCEPT would return the max release date without giving context to the row. 

Any help is appreciated! Thanks!

[Phil_Seamark · Accepted solution]

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.

[khappersett]

@Phil_Seamark

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'))

[Phil_Seamark]

Cool.  Is 'Account Detail' the same field as 'Wholesale ID' ?

[khappersett]

@Phil_Seamark

The Wholesale ID field is found in the Account Detail table.