Forum Discussion
Solved
Another MIN problem
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.
Well it worked, thank you so much Fowmy
3 Replies
Hi leonardoficz ,
is it possible for you to share a sample file with sensitive data removed ?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 __COWell it worked, thank you so much Fowmy
