Forum Discussion

a-simarg's avatar
a-simarg
Helper II
6 years ago

Count from the first seen

Hello   My data header looks like this: Customer ID |  Earliest seen date |Filter Date|   I want to count the number of times a unique client has been detected.It should be based on the main dat...
Need Help
a-simarg's avatar
a-simarg
Helper II
6 years ago

Hi amitchandak 

 

i would like to use only a single date filter and that one to be "Filter date"

 

Thanks

Simona

amitchandak's avatar
amitchandak
Super User
6 years ago

Not able to get the problem you are facing. 

If you add a slicer for filter date and select the count of customer id  in visual.

  • a-simarg's avatar
    a-simarg
    Helper II
    6 years ago

    The earliest seen date it is also a calculated measure 

    Earliest seen = CALCULATE(MAX('DATA Table'[Earliest Seen Date]),USERELATIONSHIP('DATA Table'[Earliest Seen Date_],'Table'[Date]))
     
    where :
    Earliest Seen Date_ = DATE(YEAR('DATA Table'[Earliest Seen Date]),MONTH('DATA Table'[Earliest Seen Date]),DAY('DATA Table'[Earliest Seen Date]))
    Table Data it is a new table created by me with fy 20
     
    i want to calculate the number of times a unique client has been detected from the earliest seen date in the date range selected