Total sum for Customer is not equal Distinctcount

[UntamanEi]

Hi, 

I would like to calculate the summation of the Distinctcount Customer that shows a unique customer but I would like summation value.

This is my DAX.

_Count Customer = SUMX(ALLSELECTED(Sheet1[Customer]), CALCULATE(DISTINCTCOUNT(Sheet1[Customer])))

This is the Data Table.

Date	Transaction	Customer
9/2/2020	MM01	A
9/2/2020	MM02	C
9/20/2020	MM03	B
9/22/2020	MM04	A
10/1/2020	MM05	B
10/3/2020	MM06	A
10/5/2020	MM07	B

Best Regards,

[AlB · Accepted solution]

Hi @UntamanEi 

Using your current measure, and if you are going to use it with months (DateT[Month]) on the row of the visual as shown:

_Count Customer_TOT =
SUMX( DISTINCT(DateT[Month]), [_Count Customer])

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers