Forum Discussion
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...
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] ) )
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
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] )
)
AlBCommunity Champion
Community ChampionAnonymous
...and another one:
ResultTable =
FILTER (
Table1;
Table1[Rate] = CALCULATE ( MIN ( Table1[Rate] ); ALL ( Table1[Rate]; Table1[Carrier] ) )
)