Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

PowerBI Functionality/Strategy Question

In an example data set listed below, what is the best way to sum column 2 without taking into account duplicates from A(2) or A(3)? The goal is to only sum up the assignee of each letter only once. Removing duplicates would not work because if 6 was ever assigned to another letter in the future it would be filtered out.

Example Data Set

Column 1   Column 2

A (1)                     6

B                           8

C                            9

A (2)                     6

C                             9

A (3)                     6

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

Click Query Editor-> Click “Split Column” like below:

Capture.PNG  

 

After remove useless column, then click "Remove Rows"-> "Remove Duplicates".

2.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

Click Query Editor-> Click “Split Column” like below:

Capture.PNG  

 

After remove useless column, then click "Remove Rows"-> "Remove Duplicates".

2.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi @Anonymous 

Go to edit queries.

Right click your column 1 and remove duplicates.

Then sum up your table.

Ta!

2019-04-09 10_56_14-papercut - Remote Desktop Connection.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.