Sum values based on distinct ID, group by another column

[Anonymous]

Hi Everyone. I need some help:

I am trying to display a pie chart, of grouped and sum values based on a distinct ID

My data looks like this:

ID	Amount	Code
1	220	G
1	220
2	350	F
2	350
2	350
3	125	G
3	125
4	220	F
4	220

Currently, I am using filters and sum measures but my results are summing every value, not the one value based on the ID. My current results are as so:

Total Sum = 2180

Group G: Sum = 690

Group F: Sum = 1490

Which is incorrect, as it is summing every value.

I need my results to be: 

Total Sum = 915

Group G: Sum = 345

Group F: Sum = 570

As I am trying to display these groups in a pie chart. 

Anyone have a fix for this? Thanks in advance

[Ronald123]

@Anonymous,

TotalAmount = SUM('Table'[Amount])

Greetz,

Ronald

[Anonymous]

This gives me the same incorrect results unfortunately. 

[Ronald123]

@Anonymous ,

Please, share a sample oy your data.

It isn't logic to gets incorect value's.

Greetz,

Ronald

[Anonymous]

Unfortunately I can't share the actual data:

However it looks like this: 

ID	Amount	Code
1	20	G
1	20	J
2	40	G
2	40	Y
2	40	J
3	65	F
3	65	Y
4	100	F
4	100	Y
4	100	J
5	50	G
5	50	Y
5	50	J
5	50	N
6	20	F
6	20	J

I want to sum the Amount(only one value for each ID) based on the ID, and grouped in group G or F (not interested in the other codes). Because the amounts are repeated for each ID, it sums all the amount values. 

[Ronald123]

@Anonymous ,

What are the expected values for the code:

G :
F :

Greetz,

Ronald

[Anonymous]

G = 110 

F = 185 

Total = 295 

I think the total is the problem, it isnt summing only codes G and F it's including every single amount listed.

So my total ends up being 830 instead of 295

Thanks Ronald for your help 🙂 

[Ronald123 · Accepted solution]

@Anonymous ,

Check the file;

https://1drv.ms/u/s!An5X7wdH9O9eiWvhOWkMJrheqa9H

Greetz,

Ronald

[Anonymous]

That made things much clearer!. Thank you Ronald, I have solved my problem

[Anonymous]

Hi all,

I have the same problem than @Anonymous , but I am not able to reach de link information.

Please, @Ronald123 , can you share it again?

Thanks in advance.

Paco.