Create Dax measure calculates number of occurrences of every pair of services purchased by clients

[mostafatalaat37]

i want to create Dax measure that calculates number of occurrences of every pair of services purchased by clients 
- i have a table with 2 columns client name , service name
- i want to create a measure that shows the number every pair of services are purchased together 
- the output should look like the pic attached , where services names in rows and columns
where one service can't be purchased twice by the same client  ,
but service 1 and service 2 were purchased together one time by 1 client 
and service 2 and service 4 were purchased together 2 times  , ect

[Anonymous]

Hi  @mostafatalaat37 ,

According to your data, when Row=services2,Column=services1,the result is 3, when Row=services1,Column=services2,the result is 1, but there is only one column [services], not very clear about the logic, if it is convenient, can you explain the calculation logic and share the sample If it is convenient, can you explain the calculation logic and share the sample output in data and table format, or the pbix sample after removing the sensitive data. We can better understand the problem and help you out.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly