topic Create Dax measure calculates number of occurrences of every pair of services purchased by clients in DAX Commands and Tips

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

mostafatalaat37 — Tue, 21 May 2024 21:07:09 GMT

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

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

Anonymous — Wed, 22 May 2024 01:50:29 GMT

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