Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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])
Solved! Go to Solution.
Adding the numbers in your visual totals 48. There must be some other reason you are not getting 49
Adding the numbers in your visual totals 48. There must be some other reason you are not getting 49
my mistake, am using a excel table for refencen and in my excel table give 49, decimal number give me worng result.
Thanks @MattAllington
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |