Forum Discussion
Count users based on same day activity
You need the evaluate the measure date by date to replicate what is happening in the chart. Use this measure (that uses the one you have already) in the chart and in the card:
Same Day Order & Wifi TOT = SUMX( DISTINCT('Date Table'[Date]), [Same Day Order & Wifi])Note there is no need for the CALCULATE in [Same Day Order & Wifi]. You can get rid of it
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi obothewizard
Can you share the pbix (with dummy data reproducing the issue if necessary) or show samples of your relavant data?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi there,
Thanks so much for your reply.
I've attached a pbix as requested. Essentially I need a distinct count of customers per day who appear in both the order and wifi logins tables on the same date - so need to write a measure that matches on ID and date.
In the workbook, the bar chart shows daily vols of wifi with orders customers for January 2020, these are the correct figures. However the card beneath which uses the same measure is showing the wrong value - I did some spot checking of the data in excel and the count should be 44 custs not 62 as shown in the card. The daily volumes add up to 44 in the chart, but when I expand the date drilldown to monthly, it then reflects 62 which is wrong.
Please let me know if you need anymore info, and thanks very much for your help
Sorry how do I attach the pbix workbook? Can't see any obvious button!