Forum Discussion

obothewizard's avatar
obothewizard
Helper I
5 years ago
Solved

Count users based on same day activity

Hi there,    I am trying to write a measure which will pull in a count of all users by day who have made an order and also logged into wifi. The order and wifi tables are separate and are linked wi...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    obothewizard 

    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 

     

AlB's avatar
AlB
Community Champion
5 years ago

obothewizard 

It loosk liek the linke requires signing in. Please remove the requirement or host it elsewhere....or just upload the file to a site like tinyupload.com (no sign-up required).

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