Set Analysis help max value present in the sum of values

[Anonymous]

Hi i have date dimension i need to identify the date which has the maximum sum of sales amount.

[Anonymous]

stalwar1‌

[sunny_talwar]

May be this

FirstSortedValue(Date, -Aggr(Sum(Sales), Date))

[Anonymous]

Sunny i am having  issue i am not getting the right total let me attach excel data.

[Anonymous]

I want that 9717 to be captured. Attached is the data.

[sunny_talwar]

Right total? Means total at the top for all dates?

[sunny_talwar]

So this table should only show you 10/07/2016 and no other date?

[Anonymous]

it can show other dates as well. Technically i want that number in a text box. but for all dates the value should be maximum value .....