Filter 0 and smallest value greater than zero from dataset

[muhamazh]

Hello there,

I have a dataset that contains the following:

I only want to take the time value 0 and one value greater than zero from the dataset.

We can filter for any value greater than or equal to zero but what would be the way to filter only one value greater than zero for each Event? Thanks

[tamerj1]

Hi @muhamazh 

in general you can first filter out the negative time values then calculate the TOPN ( 2, of the filtered table,  [Time], ASC )

what is the expected result?

[muhamazh]

It only displays the first two from all the table. But I want the first two values from each Event. Like 2 for A, 2 for B, 2 for C etc. Thanks

[tamerj1]

@muhamazh 
Yes indeed you are right. So the table that you need to filter should be CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Event] ) ). There is more t be done here but do this first and let me know what do you get.