Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi,
I wanted to find the least selling product per category, in this case I'm looking to get FlipFops, T-shirts & Bracelets.
where I need to indicate the product with different conditioned format.
Please advice any suggestions to do it.
Business Category | Products | Sales |
Footwear | Sneakers | 50 |
Footwear | Flipflops | 26 |
Footwear | Winter Boots | 63 |
Apparel | T-shirts | 2 |
Apparel | Joggers | 23 |
Apparel | Shorts | 16 |
Jewelry | Rings | 8 |
Jewelry | Necklace | 6 |
Jewelry | Bracelets | 2 |
@GuruBMO Put Business in a table visualization along with this measure:
Least Value Product =
VAR __Min = MINX('Table',[Sales])
VAR __Result = MINX(FILTER('Table',[Sales] = __Min),[Products])
RETURN
__Result
User | Count |
---|---|
9 | |
8 | |
5 | |
4 | |
3 |