Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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' ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |