first to second order customer combinations

[Jameswh91]

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?

[Jameswh91]

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.

[v-zhangti]

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

[amitchandak]

@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.