Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a new Table to show the Minimum value based on multiple criteria

I'm trying to create a new Table to just have the minimum cost carrier based on 3 criteria - Origin Zip, Destination Zip, Mode  This is my initial data:   I'm looking for end result to be si...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    Another way..Shorter Code

     

    Calculated Table 1 =
GENERATE (
    SUMMARIZE (
        Table1,
        [3 digit Origin Zip],
        [3 digit Destination Zip],
        [Mode],
        "Lowest Rate", MIN ( Table1[Rate] )
    ),
    SELECTCOLUMNS ( FILTER ( Table1, [Rate] = [Lowest Rate] ), "Carrie", [Carrier] )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

AlB (I'm not a DAX expert) When I used the one you posted it gives me all the values rather than Just least cost carrier.

AlB's avatar
AlB
Community Champion
7 years ago

Anonymous

 

Maybe you did something differently. It should work.

Check it out in this file. It yields exactly the same result as you showed above.