In a Power BI data model a one-many relationship can have its cross-filter property set to ‘single’ or ‘both’ and invariably I find that the ‘both’ setting confuses people. So let’s set up a really simple data set and see how this works in detail.