Forum Discussion
first to second order customer combinations
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?
3 Replies
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-measuresTOPN 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.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.
