PowerBI Functionality/Strategy Question

[Anonymous]

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

[Ashish_Mathur]

Hi,

Hope this helps.

[v-yuta-msft · Accepted solution]

@Anonymous ,

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

  

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

 

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]

Hi @Anonymous 

Go to edit queries.

Right click your column 1 and remove duplicates.

Then sum up your table.

Ta!