topic Sum of Customers for multiple values in same column in DAX Commands and Tips

Sum of Customers for multiple values in same column

ManjunathaEP — Fri, 22 Jan 2021 08:39:19 GMT

Hello, I have 2 requirements from the below sample data:

Requirement 1: I want to get the distinct count of customers, who has Y/N? equals Y and N. In the below sample data, I should get customer distinct count is 2 (Cust.Name= XYZ and ANF)

Requirement 2: I want to get the sum of the distinct customers, who have Y/N? equals Y and N. In the below sample data, I should get a sum of distinct customers of XYZ and ANF for Y and N = 610 (123+344+66+77) and also I should get the total sum of Y, who is equals to Y & N, expected answer is = 347 (123+344)

Cust.Name	Y/N?	Amount
XYZ	Y	123
ANF	Y	344
ABC	Y	555
JUF	Y	222
KIF	Y	33
JUS	Y	55
KFF	Y	7676
LSF	Y	33
XYZ	N	66
ANF	N	77
SRE	N	88

Re: Sum of Customers for multiple values in same column

Payeras_BI — Fri, 22 Jan 2021 11:20:34 GMT

Hi ManjunathaEP ,

Not sure if I understood correctly the third requirement. For me the result would be 467 (123+344).

Regards,

Re: Sum of Customers for multiple values in same column

ManjunathaEP — Fri, 26 Feb 2021 01:38:58 GMT

Hi, In the above example, I would like to get the count of the only Y, who is not Y and N.

Example: Customer Name: Total count of customers is 6 (ABC, JUF, KIF, JUS, KFF and LSF) who are not part of Y and N. Please help on this and thank you in advance

Re: Sum of Customers for multiple values in same column

Payeras_BI — Fri, 26 Feb 2021 09:26:20 GMT

Hi ManjunathaEP,

The same way as in your previous Requirement 1 but, in this case, switching > by =.

BTW the result is 7.