Filter matrix column to only display last letter

[Anonymous]

I have a matrix displaying information on upcomming changes to parts our company manufactures. For each change there is a revision level. I am having issues only displaying the latest revision level. Usually there is an option for displaying first, last, sum, etc. , but it is not available. Is there a way to get the same functionality as the "last" option through DAX? Our revisions level are denoted by letters. I'm sorry I can not provide any of my reports due to our security policies. 

[parry2k]

@Anonymous not sure how your data looks like but something like this will work

Assuming you have product table with unique values and have relationship with revision table on product code/id

Recent Revision by Product = 
CALCULATE ( MAX ( Table[Revision Number] ), ALLEXCEPT ( ProductTable, ProductTable[Product] ) )

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

It is still returning multiple revisions levels instead of only the most current.

[Anonymous · Accepted solution]

I found a different data set form SAP that only displays the current revision level related to the most recent changes. No longer need a solution for this issue. Thank you for help!