topic Re: first to second order customer combinations in DAX Commands and Tips

first to second order customer combinations

Jameswh91 — Mon, 14 Mar 2022 10:26:02 GMT

Hi,

I am looking to create a visual showing the most common first to second order combinations for our company. Is there any chance someone can help me with the DAX for this?

Re: first to second order customer combinations

amitchandak — Mon, 14 Mar 2022 11:54:12 GMT

Jameswh91 , You can use RANK or TOPN

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

TOPN https://youtu.be/QIVEFp-QiOk

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: first to second order customer combinations

Jameswh91 — Mon, 14 Mar 2022 14:57:08 GMT

Thanks, can this be expanded to give combinations of say, 1st and 2nd orders?

e.g 10% of customers may buy socks first and a baselayer second.

Re: first to second order customer combinations

v-zhangti — Thu, 17 Mar 2022 07:25:58 GMT

Hi, Jameswh91

Can you provide some sample data for testing? What kind of results do you expect and can you also show them with pictures, thanks.

Best Regards