Total from distinct values

[sixtoquiles]

HI, I need help with my distinct sum.

I have many DistricDesc with the same target, but i just want one with the his target. I did, and I want a total of all target in the table, (show below) but the total is incorrect, is supose to give me 49. Any can help me. if need more info, let me know.

sumtargets = SUMX(DISTINCT(vw_pwrbi_altas[DistrictDesc]),[targetaltas])

 

[MattAllington · Accepted solution]

Adding the numbers in your visual totals 48. There must be some other reason you are not getting 49

[sixtoquiles]

my mistake, am using a excel table for refencen and in my excel table give 49, decimal number give me worng result.

Thanks @MattAllington