Blog
Articles on keys, grain and relationships between Microsoft Fabric tables, by Gustav Kruse, Kruse Consulting AB.
Why Your Fabric Totals Double When You Join Orders to Order Lines
A join from orders to order lines is one-to-many. It repeats each order row for every matching line, so summing order_total afterwards counts each order…