Forum Discussion
leonardoficz
5 years agoRegular Visitor
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...
- 5 years ago
Well it worked, thank you so much Fowmy
Fowmy
5 years agoSuper User
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
- leonardoficz5 years agoRegular Visitor
Well it worked, thank you so much Fowmy