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!Get Fabric certified for FREE! Don't miss your chance! Learn more
Good morning everyone,
given the following table, I have to calculate the total BOM (Bill Of Materials) considering that it exploded for a single product.
How can I do?
Thanks in advance
Solved! Go to Solution.
@Franco , Try a measure like
Sumx(Summarize(Table, Table[POS], Table[Date], Table[BOM], Table[Qty]), [Qty])
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 69 | |
| 59 | |
| 47 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 106 | |
| 102 | |
| 38 | |
| 27 | |
| 27 |