FirstsortedValue and Current selection issue

[Manish]

Hi All

I have written the below mentioned expression to get branch where the count is max , which is working fine.

FirstSortedValue(Branch,-aggr(Count(DISTINCT{<DateFlag={'ReSub'},Id={"=Sum({<DateFlag={'ReSub'}>}[No Of Resubmission])<>0"}>} Id),Branch))

Now i dont want my output to be impacted or changed on a selection of a branch.

How can i achieve that ??

any help would be appreciated.

Many thanks

[Anil_Babu_Samineni · Accepted solution]

Perhaps this

FirstSortedValue({<Branch>} Branch,-aggr(Count(DISTINCT{<Branch, DateFlag={'ReSub'},Id={"=Sum({<Branch, DateFlag={'ReSub'}>}[No Of Resubmission])<>0"}>} Id),Branch))

Or

FirstSortedValue(Only({<Branch>} Branch),-aggr(Count(DISTINCT{<Branch, DateFlag={'ReSub'},Id={"=Sum({<Branch, DateFlag={'ReSub'}>}[No Of Resubmission])<>0"}>} Id),Branch))