Get distinct values in calculated table

Hey Anonymous ,

if you want to get only the earliest date, the following measure should do the job:

First Date by client =
CALCULATE(
    MIN( myTable[Date appointment] ),
    ALLEXCEPT(
        myTable,
        myTable[Client ID]
    )
)

If you only want to show the first row, you also have to replace the employee column with the following measure:

First Employee = 
VAR vFirstDate = [First Date by client]
RETURN
CALCULATE(
    MIN( myTable[Employee name] ),
    ALLEXCEPT(
        myTable,
        myTable[Client ID]
    ),
    myTable[Date appointment] = vFirstDate
)

Then you should put the two measures in a table and you get the result you want:

Hi Anonymous ,

You can create a visual level filter:

Measure = IF(MAX('Table'[Date appointment]) = CALCULATE(MIN('Table'[Date appointment]),ALLEXCEPT('Table','Table'[Client ID])),1,0)

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

Best Regards,

Dedmon Dai