topic Allow Measure using FirstSortedValue to filter in table in App Development

Allow Measure using FirstSortedValue to filter in table

ynottableau — Wed, 21 Jun 2023 02:10:07 GMT

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?

Re: Allow Measure using FirstSortedValue to filter in table

sidhiq91 — Wed, 21 Jun 2023 03:56:29 GMT

@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.

Re: Allow Measure using FirstSortedValue to filter in table

ShaneMichelon1 — Wed, 29 May 2024 03:59:09 GMT

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.