ExamplePbix Added - Select first row of different rows with same calculated column value

Hi v-yueyunzh-msft 

Firstly, thank you for your reply. I tested and could work but I should model tables because there are more rows that can be used for TimeOnCourt visualizations, so I would need to find the way to do the same with the formula created but not creating a new table. Add 2 examples of the full table and how the "TimeOnCourt" was created (not in Power Query, it was created in visualization panel).

Later, I would all an example of the full table for one game.

Hi v-yueyunzh-msft 

Firstly, hope you could enjoy your holidays. Don't have to apologize, I truly appreciate all your effort to help me. I'm gonna try to reply about your understanding:

I am not sure my understanding is the same as yours.

And for this sample data you provide , do you mean that we need to check:

(1)  the [TimeOnCount] and the [Time_Def] are all the same.    (YES) That's correct, we need to check the rows with the same [Time_Def] and same [TimeOnCount].

(2)Then i do not know the next step to find the lowest index. In my thought , i will use the current [Full_Game] ,[Full_Quarter],[TimeOnCount],[Time_Def] to find the how many [Defensive Five] in this table? Yes. usually, the result of this check should be 1 (only one Defensive Five value) except for the specific casuistry found due to a mistake in the data entry.    (In your sample , there are two [Defensive Five] = "PLAYER2 ..." and "PLAYER3 ...")??  Yes. Because it's the specific casuistry where it was an error in a data entry. Here, the result of your check it's gonna be 2 instead of 1.

(3)Then we need to get the each lowest [Index] of each [Defensive Five] ? It could be a way to find the lowest Defensive Value for this subset (the one referred in step 1, same [Time_Def] and [TimeOnCourt]). In the end, the goal is to mark the "PLAYER2..." with 1 and the "PLAYER3..." as -1.

"PLAYER2 ..."   ----- > 19242      "PLAYER3 ..."----->19257

(4)So in the end we keep the all the [Defensive Five]= "PLAYER2 ..." data ?? That's correct. We should mark all these rows for the "PLAYER2..." as 1 and all the rows "PLAYER3..." with same [Time_Def] and [TimeOnCount]. Like the example below (already added).

And what the fields you need to put on the visual ? The fields can be "DefensiveFive" or "Def3" columns, depending on the interest but I guess that if we are able to mark correctly the rows with the Flag, this could not affect us.

I do think that your understanding is the correct one. I don't know if you could access but in the link (https://drive.google.com/drive/folders/1SlzwO6bgBBgrftwrVPGRVBE9KkIy_YqJ ) you can find an Excel file with all rows of the dataset and the Flag_Expected as a result of the measure and the dated pbix with the 3 measures you told me (20220120...).

Thank you so much for your time!

Hi , sfernamer 

Thanks for your quick response and the sample .pbix file you provieded.

You can create a measure like this:

Measure = var _tt = ALLSELECTED(Hoja1)
var _t =  SUMMARIZE(_tt , 'Hoja1'[Def3] , "TimeOnCourt" , [Grouped_TimeOnCourt_D5])
var _t2 =  ADDCOLUMNS( _t , "flag" , var _time = [TimeOnCourt] var _count = COUNTROWS(  FILTER(_t , [TimeOnCourt] = _time)) return _count)
var _t3 =  ADDCOLUMNS(_t2 , "test" , var _def3 = [Def3] var _min_index =MINX(  FILTER( _tt , [Def3]=_def3 ),[Index])  return IF([flag]>1,_min_index)) 
var _t4 = ADDCOLUMNS(_t3 , "test2" , var _timecount = [TimeOnCourt] var _test = MINX( FILTER(_t3 , [flag]>1 && [TimeOnCourt] =_timecount),[test]) var _min_def3 =MINX(FILTER(_tt,[Index] = _test),[Def3])  
return IF(OR([Def3]=_min_def3,[flag]=1) ,1 ,-1)   )
var _cur_def3= MAX('Hoja1'[Def3])
var _test_flag =MAXX( FILTER(_t4, [Def3] = _cur_def3),[test2])
return
IF(_test_flag=-1,-1,1)

Then we can put the measure on the "Filter on this visual " and configure it and then we can meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly