FirstSorted showing value not at the needed row

[Micki]

Hi folks, 

I have a very basic measure with firs sorted function,

sum(AGGR(
		IF(FirstSortedValue(DISTINCT LastResultOutcome, -TIMESTAMP(AnalyticsUpdatedDate)) = 'Failed', 1,0), Title))

 It's working good but showing value not on the needed row so if you see instead of 0 should be 1.

Does it naturally for FirstSortedvalue or it's possible to change somehow? 

Thanks 

[sunny_talwar]

@Micki what all dimensions do you have in the chart? The row above should be 0, and the highlighted row should be 1?

[Micki]

Hi @sunny_talwar ,

[sunny_talwar · Accepted solution]

@Micki Try this

If(FirstSortedValue(TOTAL <T1.TITLE> T2.OUTCOME, -T2.HISTORY) = 'Passed' and T2.HISTORY = Max(TOTAL <T1.TITLE> T2.HISTORY), 1,0)

[Micki]

 thank you @sunny_talwar , based on your answer i edit a little bit measure and now it's working