I want to find the distinct count of customers who have visited a shop everyday. Is there a specific DAX or Mquery?
My plan is to create a column chart to find unique customers per day grouped monthly.
Eg: "Sam" visits Wmart today thrice and tomorrow twice. I want him to be counted once today and again counted once tomorrow. Similarly for all customers and then add the values monthly.
Would appreciate if anyone could show me how to do it.
Go to Solution.
hi, @Anonymous @ryan_mayu
So times of Sam visits Shop these two days is 2, not just distinctcount result is 1.
You could try to use DISTINCTCOUNT and SUMX to create a measure like this
Measure 2 = var _table=SUMMARIZE('Table','Table'[Shop],'Table'[Date],"distinctcount",DISTINCTCOUNT('Table'[Customer]))
View solution in original post
@Anonymous can you provide sample data and will get you the solution
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
Hi, why distinctcount formula doesnot work in this situation? Have you tried about that? Or you have some specific requirement?
Hope this is helpful.
Thanks and BR
Proud to be a Super User!
Thanks Lin. Sorry for the delay in response. Your formula worked.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.