Search code examples
excelpowerbipowerpivotcartesian-productdatamodel

Excel: DataModel - why it returns cartesian product?

Can't understand how DataModel works in Excel. Please help

Example: in Excel - why it returns cartesian product? enter image description here

At the same time absolutely the same DataModel in PowerBi returns normal estimated result: enter image description here

Download Excel file here

Solution

  • You just should drop something to Values section in pivot table: enter image description here

    P.S. Special Thanks to @Rory for the help!