Forum Discussion
undefined
Hi everyone, I want to create a measure which shows the day of the week with the highest amount of customers. Unfortunately, the DAX-function MAX doesn't work here. Our customers have ID-numbers....
- You can use TopN and RankX to get the day with highest customer visits.
Use RankX to rank the days using the current measure that you have. You can then use the TopN function to get the top day.
Thanks
Hey Anonymous !
Thanks for your response. I will try to be as clear as possible.
Our customers are visiting our locations. That is what we're keeping track of. We know how many unique visitors we have each day. We can use a date slicer to select a week, weeks, months, etc. to show the unique visitors in the selected period.
This graph has two variables: number of customers (which is a measure (DistinctCount(Customer_ID) and day_description (Monday, Tuesday, ....). This day_description is linked with our Calendar.
I hope this helps! Otherwise, let me know if you need more information.
Hi,
What exact result are you expecting?