Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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?
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
@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.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |