3 Replies Latest reply: Jul 27, 2016 5:13 PM by Conor O'Kane RSS

    FirstSortedValue Reverse (-Aggr) not working

    Conor O'Kane

      Hi,

       

      I have a function as a measure in a text box:

       

      FirstSortedValue(Distinct [Site Name], Aggr(Count([ID]),[Site Name]))


      that works and returns the Site with the lowest count of the ID variable. However, If I try to reverse this using either of the following methods:


      FirstSortedValue(Distinct [Site Name], -Aggr(Count([ID]),[Site Name]))

      OR

      FirstSortedValue(Distinct [Site Name], -1 * Aggr(Count([ID]),[Site Name]))


      I get a NULL return (i.e. a small dash and no result). Is anyone else to determine why?


      I attach a sample of the data in question.


      Thanks