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!View all the Fabric Data Days sessions on demand. View schedule
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 15 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |