Allow Measure using FirstSortedValue to filter in table

[ynottableau]

Hi All,

I created a table with Name as dimension, and the Status us a measure with this formula '=FirstSortedValue(DISTINCT Status, -Date)'

Name	Status
RefA	Completed
RefB	Pending
RefC	Removed

How can I make that measure (resulting Status column) to be able to filter (magnifying glass) on the table?

[sidhiq91 · Accepted solution]

@ynottableau  Could you please use the below expression in your Dimension:

Aggr(FirstSortedValue(Status, -Date),Name)

If this resolves the issue, please like and accept it as a solution.

[ShaneMichelon1]

This solution does not work.  Your AGGR is allowing you to select a 'Name' rather than a 'Status'.  I am not sure there is an actual solution as I have the same problem.