Another MIN problem

[leonardoficz]

Hello nice people =]

I have a problem with that thing here:

This is a shipping cost table. I need to get only the min value for each area (AC Capital, AC Interior, AL Capital, AL Interior and so on) and the name of the Shipping Company that has that value. Right now it gives me the min cost for each Shipping Company in my table.

[Fowmy]

@leonardoficz 

Insert a table visual, add the Area and the following measure to it:

Min Value = 

VAR __MINVAL = MIN(Table01[Min Shipping])
VAR __CO = CALCULATE( MAX(Table01[Shipping Co.]) , Table01[Min Shipping] = __MINVAL )
RETURN
    __CO

[leonardoficz · Accepted solution]

Well it worked, thank you so much @Fowmy 

[jaideepnema]

Hi @leonardoficz ,
is it possible for you to share a sample file with sensitive data removed ?