Forum Discussion

sixtoquiles's avatar
sixtoquiles
Icon for Helper II rankHelper II
9 years ago
Solved

Total from distinct values

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])

 

 

Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

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

2 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    9 years ago

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

    • sixtoquiles's avatar
      sixtoquiles
      Icon for Helper II rankHelper II
      9 years ago

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

       

      Thanks MattAllington