Replace values with values in other column

[only_me321]

table example

I need this 

The DAX I wrote is 

    New_Column = CALCULATE(MIN('table'[Sup_group]),FILTER(ALL('table'),
                                                                     'table'[province] = EARLIER('table'[province]) &&
                                                                     'Stable'[Quarter] = "Q1"))

The result is 

    But I don't want this kind of result, I want like the first picture.

help me please,

thank you.

[Ahmedx · Accepted solution]

​Column = CALCULATE(MIN([Sup_group]),ALLEXCEPT('Table','Table'[Group]))

If I answered your question, please mark my post as solution, Appreciate your Kudos!

[only_me321]

Oh, I can do it, just like you let me try. 👏

[only_me321]

thank you, I tried to follow you result is  

which i want like this

[Ahmedx]

You are doing something wrong, look at my file
https://dropmefiles.com/XruU9