Forum Discussion
Basic power Pivot question (why does the relationship "not work")
bartvana Your model is a bad example since both tables contain unique SKU's. In reality the (fact) table with the Quantites holds non-unique SKUs whereas the (dimension) table with the SKU and Supplier info will hold the unique SKU's.
If you drag the relationship from the fact table (the many side) to the dimension table (the one-side) it shall work.
bartvana Your model is a bad example since both tables contain unique SKU's. In reality the (fact) table with the Quantites holds non-unique SKUs whereas the (dimension) table with the SKU and Supplier info will hold the unique SKU's.
If you drag the relationship from the fact table (the many side) to the dimension table (the one-side) it shall work.
- That simple :). Fabulous, thank you!
As variant, you may remove relationship at all and using such measure
Total QTY:=CALCULATE ( SUM ( tItemQties[Qty] ), TREATAS ( VALUES ( ItemVendor[SKU] ), tItemQties[SKU] ) )- Interesting, thank you!
