Question

You are building a semantic model for a subscription business. A Customers table and a Products table have a many-to-many association because a single customer can subscribe to multiple products, and each product has many subscribers. You have a Subscriptions table that contains one row for every valid customer-product pairing. You need a measure that correctly counts distinct customers per product without inflating or losing rows, following recommended star-schema modeling practices. What should you do?

Accepted Answer

Use the Subscriptions table as a bridge table, create single-direction one-to-many relationships from Customers and Products into it, and enable cross-filtering as needed for the count measure.

Answer

Create a direct many-to-many relationship between Customers and Products and rely on Power BI to expand the cardinality automatically.

Answer

Merge Customers and Products into one flattened dimension table so that no relationship is required.

Answer

Create a calculated column in Products using RELATED to pull each customer name, then count the column.