Forum Discussion

beaoliv123-_'s avatar
beaoliv123-_
Helper I
4 years ago
Solved

Dynamic Unique Visitors

Hi,  I would like to calculate the number of unique visitors based on the date range that the user decides to see. For example, if I select a date between last week and today, I would like to see th...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi beaoliv123-_ ,

     

    You may firstly refer to Whitewater100 's pbix.

     

    And I have created a data sample to test:

    And use CALENDAR() to create a Date table for slicer:

    For Slicer = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

    Then create a measure:

    Count of Unique Users = CALCULATE(DISTINCTCOUNT('Table'[User ID]),FILTER('Table',[Date]>=MIN('For Slicer'[Date]) && [Date]<=MAX('For Slicer'[Date])))

    Output:


    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

beaoliv123-_'s avatar
beaoliv123-_
Helper I
4 years ago

Table1

Date
User ID (each time a user comes in, the user ID appears)

 

 

Table2
Year
Quarter
Month
Day

 

 

My goal is to calculate the distinct user ID, but this measure must be dynamic with the date.

Ex.:
If I select a date between last week and today, then it will count each user ID once between these two dates. And depending on the date selection, I want the distinct count to change.