cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Sum of Customers for multiple values in same column

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.NameY/N?Amount
XYZY123
ANFY344
ABCY555
JUFY222
KIFY33
JUSY55
KFFY7676
LSFY33
XYZN66
ANFN77
SREN88
1 ACCEPTED SOLUTION
Super User I
Super User I

Hi @ManjunathaEP ,

 

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

 

Payeras_BI_0-1611313440642.png

Payeras_BI_1-1611313462860.png

Payeras_BI_2-1611313479616.png

Regards,

 


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos :winking_face:
Mallorca, Spain

View solution in original post

3 REPLIES 3
Super User I
Super User I

Hi @ManjunathaEP,

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

BTW the result is 7.

Payeras_BI_0-1614331339029.png

 

 

 


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos :winking_face:
Mallorca, Spain
Regular Visitor

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

Super User I
Super User I

Hi @ManjunathaEP ,

 

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

 

Payeras_BI_0-1611313440642.png

Payeras_BI_1-1611313462860.png

Payeras_BI_2-1611313479616.png

Regards,

 


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos :winking_face:
Mallorca, Spain

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.