Forum Discussion
Keeping 1-2 duplicate values
Hi all
Wondering how it would be possible to filter through a table and keep duplicate values up to a maximun of 2?
Ticket: 1244 | Sam |
Ticket: 1456 | Sam |
Ticket: 1789 | Sam |
Ticket: 2567 | Mark |
Ticket: 3267 | Mark |
Logic would be to review only maximun 2 tickets to review.
How would I remove the 3rd ticket from Sam for the table to only contain max 2 duplicate values of the 2nd collumn?
3 Replies
hi muggydaniel
1. You can Rank on the basis of ticket number within name partitions
rank = RANKX(ALLEXCEPT('Table','Table'[Name]),CALCULATE(SUM('Table'[Ticket])),,DESC)2.Set the limit of Rank as 2 and then you will get only 2
Ticket: 1244
Sam 1 Ticket: 1456
Sam 2 Ticket: 1789
Sam 3 Ticket: 2567
Mark 1 Ticket: 3267
Mark 2 You can watch my video https://youtu.be/ckR46zdNexk
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification SeriesHope it helped!
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification SeriesDid it help ?Then please mark it to help the community as well
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
