What is the best way to find min values 5 columns or measures for a given table row or visual row?

If you want to find the minimum value between two columns or measures with certainty, you may use the function directly:


MIN([Col1], [Col2])
MIN([Measure1], [Measure2])
Alternatively, to find the value in more than two specified columns or measures, the correct way to achieve this would be to use the function with a DAX table expression.


To list the columns in the expression that will create the DAX table for you, put curly braces {} and list them.

For example, to find the minimum value among columns (Col1, Col2, Col3), you would write a DAX table expression like this: {[Col1], [Col2], [Col3]}.

Then you could run MINX over the elements in this table to find the minimum value. Like so:

MinValue = MINX({[Col1], [Col2], [Col3], [Col4], [Col5]}, [Value])
Or for multiple measures:

Min of Five Measures = VAR temp = {[Measure1], [Measure2], [Measure3], [Measure4], [Measure5]} RETURN MINX(temp, [Value])