Overlapping Products

[ani_informa]

Hi 

I have a requirement wherein I want to count distinct employeeId for the products. For example, from the sample data below, 2nd snap is the sort of required output. If we look at the output highlighted at the intersection of Product_1 and Product_2, it is showing 2 which is distinct of employeeid that purchased product_1 as well as Product_2 (EmployeeId counted here are E1111, E1222). What is the efficient way to handle such requirement if anyone else had already encountered such requiremenet before.

[ani_informa]

Thank You for your response !!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[ani_informa]

Thanks for your response !!

I have added the sample data however I am not certain which visual we can use to show data in the output format but I was thinking if we can use Matrix. Please suggest if we can present this data in any other visual more efficiently.

EmployeeId	Product
E1111	Product_1
E1111	Product_2
E1111	Product_3
E1222	Product_1
E1222	Product_2
E1222	Product_3
E1222	Product_4
E1223	Product_2
E1223	Product_3
E1223	Product_4

[lbendlin · Accepted solution]

see attached.  Can probably be simplified.