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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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