Count distinct customers by highest segment / last date

[CuriousMonkey]

Hello,

I am looking for a measure to use in a table showing all shopping segments and the distinct number of relevant customers.

There are << 3 >> different customers with multiple visits but in my final table I just want to see each counted once - shown in the highest ShoppingSegment (is determined by the latest ShoppingDate).

I have been working with 

CALCULATE(

    DISTINCTCOUNT('table'[Customer]),

    FILTER ( 'table', 'table'[ShoppingDate]  = LASTDATE ( 'table'[ShoppingDate] ) )

)

but when matching my result with the segments table I just receive the number of distinct customers for the very latest ShoppingDate within the whole table but not just for each single Customer...

Can you help me, please 🙂 ?

Thanks a lot!

CuriousMonkey