Convert column to measure, so I can find min/max of it.

[divergent]

Hello, 

My target is to make a card showing the fastest airline (so extract top 1 row, with minimum time)

This is how my data looks, 

I am struggling to convert 'Flight_duration' column into a measure with same values, so I can then use a MINX function over it to create a min_duration measure, which I can later use to compare and use topN fucntion to just show the first value. 

I have a 'flight duration' column in my table. 

[Dangar332]

hI, @divergent 

try below

measure =
 max(tablename[flight_duration])

[divergent]

Thank you for your reply. 

What you suggested, apparently creates a measure with max values. What I am doing / trying to do is this: 

1. Convert somehow flight_duration column into a measure. 

tried this 

min = MIN('Indian Airlines'[Flight_duration])

2. Create a new measure to find the minimum value

min_fly_time = MINX(
                    ALLSELECTED('Indian Airlines'[airline]),[min]
)

3. Find / extract top (minimum value) 

Fastest_flight = //to check minimum time required by flight
    CALCULATE([min_fly_time],
        TOPN( 1, 
                FILTER(
                        VALUES('Indian Airlines'[airline]), [min_fly_time] = [min]
                ), [airline]
        )
    )

Can you spot where I am going wrong? I am unable to achieve the goal of extracting the top row.

[Dangar332]

hi, @divergent 

update your second measure to below

min fly = 
CALCULATE(MIN(flight[flight duration]),REMOVEFILTERS(flight[flight duration]))

[divergent]

Thank you that helps, but not entirely. 

Right now I am getting this 

However, I am seeking to get the output as airline name corresponding to this min_fly_time.  

My apologies for being a troublemaker 🙂

[Dangar332]

HI, @divergent 

check below image

[divergent]

Is there anyway, I could only get 'spice jet' as output that corresponds to the lowest value 1.6 in your final column, as that is exactly what I am trying to  achieve. 

We are getting close 🙂

[Dangar332]

HI, @divergent 

check below link 
click HERE