Forum Discussion
Solved
Basic power Pivot question (why does the relationship "not work")
I made a PowerPivot model and am wondering why PowerPivot cannot make an aggregation by dimension (row). This is a very basic question but it would help me a lot to understand how these models work i...
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.
Interesting, thank you!
Above is only to illustrate other possibilities. From performance point of view physical relationship is always preferable, if use virtual one when better TREATAS.