Help with DAX for SUM of Distinct values

[ERing]

I have data like below in a table and need a measure that will show me the sum of the distinct Customer_Count values. I'll have a slicer for Brand so that when all brands are selected, the measure should return 2017 (500+675+470+372). If one of the Brands is selected, for example 'Solutions', the measure would return 675.

Seems like it should be easy, but I've not been able to figure out the DAX for it.

Customer_ID	Brand	Customer_Count
1	Premier	500
2	Solutions	675
3	Central	470
4	Mighty	372
5	Premier	500
6	Solutions	675
7	Central	470
8	Mighty	372
9	Premier	500
10	Solutions	675

[Ahmedx · Accepted solution]

pls try this

[ERing]

@Ahmedx Worked perfectly. Thanks!