Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 similar to this:
Thanks
Solved! Go to Solution.
@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
One way is to have calculated table from modelling tab
Calculated Table = ADDCOLUMNS ( SUMMARIZE ( Table1, [3 digit Origin Zip], [3 digit Destination Zip], [Mode], "Lowest Rate", MIN ( Table1[Rate] ) ), "Carrier", CALCULATE ( MIN ( Table1[Carrier] ), TREATAS ( { ( [3 digit Origin Zip], [3 digit Destination Zip], [Mode], [Lowest Rate] ) }, Table1[3 digit Origin Zip], Table1[3 digit Destination Zip], Table1[Mode], Table1[Rate] ) ) )
@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
...and another one:
ResultTable = FILTER ( Table1; Table1[Rate] = CALCULATE ( MIN ( Table1[Rate] ); ALL ( Table1[Rate]; Table1[Carrier] ) ) )
@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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |