Forum Discussion
Overlapping Products
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.
see attached. Can probably be simplified.
4 Replies
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-Forum/ba-p/963216
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/1447523Thanks 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 see attached. Can probably be simplified.
Thank You for your response !!
