Help with combining firstnoblank and allexcept

[Anonymous]

Hi all,

I have some trouble combining ALLEXCEPT with firstnoblank and summarize. My statement looks like this now: 
 

var max1_y = FIRSTNONBLANK(

    SUMMARIZE(TOPN(1,

        SUMMARIZE(data, data[year], "sales amount", SUM(data[sales])),

        [sales amount], 0

        ), data[year]),1)

However, I would like to include ALLEXCEPT to the statement which I do not manage.
Is that possible? Or can I rewrite in another way to achieve the same thing? (I want to get the year with the greatest sales, and then the same for the year with the loweest sales).
Can anyone help me with this? 

Any help is greatly appreciated!

[amitchandak]

@Anonymous , I think new index function can do a better job

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

like

Maxx(index(1,addcolums(allselected( data[year]), , "sales amount", SUM(data[sales]), orderby([sales amount],desc) ), data[year])

[Anonymous]

Hi @amitchandak,

Thanks for your response. Unfortunately, I can't get it right with your code. It seems to be a problem with the AddColumns part. 
Do you have any further suggestions? 

Many thanks!