topic undefined in Desktop

undefined

Anonymous — Fri, 29 Mar 2019 15:11:19 GMT

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. To calculate our customers, I had the use a measure with the function DistinctCount. So, is there a way to solve this?

Re: undefined

Anonymous — Fri, 29 Mar 2019 15:44:41 GMT

Hey Anonymous !

I'm not too sure what part of the data model you are trying to use to arrive at your desired outcome.

Obviously, you have some table that display days of the week, & some table with customer ids.

Which customer activity are you wanting to track during the weekdays? Are they filling out surveys? Are they visiting your location? Are they purchasing items?

Do you have sample data you can provide?

Re: undefined

Anonymous — Fri, 29 Mar 2019 19:31:16 GMT

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.

Re: undefined

Ashish_Mathur — Sat, 30 Mar 2019 00:17:36 GMT

Hi,

What exact result are you expecting?

Re: undefined

Nishantjain — Sat, 30 Mar 2019 02:52:16 GMT

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

Re: undefined

Anonymous — Mon, 01 Apr 2019 13:03:07 GMT

Hi Nishantjain and Ashish_Mathur ,

Thank you for your respons and interest. The Rankx formula was the one I needed. Maybe I need to fine tune the tables (and thus some formulas) in the future, but for no it is sufficient.

Thanks.