calculate Measure of MIN/MAX based on another measure taking into account data range

[okiselova]

Could you please help me with formula. Unfortunately I couldn't find solution.

I need to find MIN stock between all dates in the range of data - Country&Product group&Sku name. The problem is that I want to calculate it on another Measure basis (Calculated stock). I managed to find min stock, but it it finds min stock in all data, not separatly by every country, product group and SKU.
Please see the example below. 

 Thank you!!!

[amitchandak · Accepted solution]

@okiselova , Assume your measure is calculated Stock

the over all min

calculate(minx(summarize(Table, Table[Country], Table[Product code], Table[SKU], Table[Year]),[calculated Stock]), allselected(Table))

Country level min

calculate(minx(summarize(Table, Table[Country], Table[Product code], Table[SKU], Table[Year]),[calculated Stock]), filter(allselected(Table), Table[Country] = max(Table[Country])) )

[amitchandak · Accepted solution]

@okiselova , Assume your measure is calculated Stock

the over all min

calculate(minx(summarize(Table, Table[Country], Table[Product code], Table[SKU], Table[Year]),[calculated Stock]), allselected(Table))

Country level min

calculate(minx(summarize(Table, Table[Country], Table[Product code], Table[SKU], Table[Year]),[calculated Stock]), filter(allselected(Table), Table[Country] = max(Table[Country])) )

[okiselova · Accepted solution]

Dear @amitchandak ,

Thank you very much! It works perfectly!🙂

Now I understand what was my mistake.