You can create set to achieve that.
Once you create this set drag it to filter self. Drag retailor number to label and measure count distinct you'll get below view.
I've attached the workbook (version 9.2) for your reference. Feel free to ask If you've any query.
Book5 - modified.twbx 23.6 KB
Have you got the answer? Let us know!