Forum Discussion
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 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!
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.
4 Replies
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' ?
