How to filter the temp table created as VAR using UNION in DAX measure

[Anonymous]

Hello everyone

I have a question about how to filter the temp table created as VAR using UNION in DAX measure

VAR tempTABLE =
UNION (
ROW ( "row1", [measure1],"row2", [measure6]),
ROW ( "row1", [measure2],"row2", [measure7]),
ROW ( "row1", [measure3],"row2", [measure8]),
ROW ( "row1", [measure4],"row2", [measure9]),
ROW ( "row1", [measure5],"row2", [measure10])
)
RETURN
MINX(tempTABLE,[row2])

By now, I can just only return the minimum value of row2 but my task is to return row2 where the row1 is minimum like if the minimum of row 1 is [measure3] then the DAX will get the value from [measure8]
how to filter the tempTABLE with the logic above.

Thank you in advance

[mahoneypat · Accepted solution]

Here is one way that should work.

Min Measure =
VAR tempTABLE =
    UNION (
        ROW ( "row1", [measure1], "row2", [measure6] ),
        ROW ( "row1", [measure2], "row2", [measure7] ),
        ROW ( "row1", [measure3], "row2", [measure8] ),
        ROW ( "row1", [measure4], "row2", [measure9] ),
        ROW ( "row1", [measure5], "row2", [measure10] )
    )
VAR vMinRow1 =
    MINX ( tempTABLE, [row1] )
RETURN
    MINX ( FILTER ( tempTABLE, [row1] = vMinRow1 ), [row2] )

Regards,

Pat

[Anonymous]

Hey, I tried the code above, it works. Thank you very much