Forum Discussion
Total sum for Customer is not equal Distinctcount
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,
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
1 Reply
- AlB
Community Champion
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