Forum Discussion
DAX
one possible solution is to create a reference (or duplicate) of this table in power query. Then add unpivot step to transofrom the data to show each row representing a customer and each column representing a plan. If a plan is available the value would be 1 otherwise it will be 0. 0 also represent the cross sale opportunities.
This new table can also be linked back to the original table via data model. This obviously works better if you don't have too many products...
Can you please suggest a DAX measure to achieve this?
it's hard to say... roughly how many products do you have? Also I'd imagine you'll have different associated production groups right Product 10 and Product 4, Product 1 and Product 2 and 3? How would the interaction work, do you use a filter for products so when you select product 10, it gives you the "number of target customers"?
Around 25