Role-playing dates: inactive relationship + USERELATIONSHIP vs duplicate dimension

This sheet compares Inactive relationship + USERELATIONSHIP, Duplicate dimension table.

CriterionInactive relationship + USERELATIONSHIPDuplicate dimension table
Filter by multiple roles in one visual at onceNot possible: only one role is active per measureSupported: each role table has its own active relationship

The verdict, the full comparison, 4 rules and 2 traps are part of PL-300 access. Unlock PL-300.