Help! Count the number of unique values

[Anonymous]

I have the above data set -

How do I find the count just the first "In" for each name ? I have more than 100 names

THanks!

[TomMartens · Accepted solution]

Hey,

my Data looks like this:

I created these two calculated columns:

Is 1st In = 
var _Name = 'Table'[Name]
var _Date = 'Table'[Date]
var FirstIn = 
    CALCULATE(
        MIN('Table'[Date])
        , FILTER(
            ALLEXCEPT('Table' , 'Table'[Name])
            , 'Table'[Name] = _Name
        )
    )
return IF(_Date = FirstIn , TRUE() , FALSE())

and

1st In = 
var _Name = 'Table'[Name]
var FirstIn = 
    CALCULATE(
        MIN('Table'[Date])
        , FILTER(
            ALLEXCEPT('Table' , 'Table'[Name])
            , 'Table'[Name] = _Name
        )
    )
return FirstIn

This allows to create a table visual like so:

But of, course you also might consider to change the DAX of "Is 1st In" in a way that it does not return TRUE or FALSE, but instead 1 and 0, then you can simply use the default aggregation SUM.

Hopefully this provides what you are looking for.

Regards,

Tom