how to sum the vallue based on the distinct count

[Chanleakna123]

Hi all , 

i'd like to sum count based on the customer name with only distinct count , please read the blue text. 

the result of Distinct Count should be = 3 , ( Becasue the Customer Name who duplicated , count only 1 ) 
Not = 4 , 

how to acheive this ? 

I also have Flavour column , if i filter Flavour : Fruity it will be 2 , 

it i filter Strawberry , it will be 3 , if i unfilter all , it will be sum only 3. 

Abit complicate here. can anyone help me ? 😞 

thanks 

• Tutorial Requests

[kcantor]

@Chanleakna123 

I am not sure I am reading your request correctly. Are you wanting to count the number of  Customer Names that buy Strawberry or Fruity?

If so, use the ALL function to remove the customer name row level filter from the calculation. For example:

All Customers = CALCULATE(DISTINCTCOUNT(Table[Customer Name]), ALL(Table))

[Chanleakna123]

Hi @kcantor  , it doesn't reflect to what i prefer , 

actually , i have issue with sum on the value based oon the distinct count of customer Name , 

When i filter something it doesn't reflect to each other ,( it counts all of the row ) , 

this is not right and this is not what i am looking for , 

i only need to see the #Customer (Distinct Customers ) of sum the value , when i filter something , it reflect to all. 

[kcantor]

@Chanleakna123 

I do not think I am understanding your request. The distinct count should provide the number you need. I only added the filter removal to show the complete count of customers because that is how I interpreted your request.

Can you provide some sample data and maybe an example of what you expect the final result to look like (manually created).