Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have data like below Tbl 1 and values are repeated but i need to sum distinct value only see Tbl 2.
Tbl 1 :
Tbl 2 :
Thanks,
KV's
Solved! Go to Solution.
@Anonymous , Create a measure like
sumx(summarize(Table, Table[market], table[ID], Table[value]), [Value])
@Anonymous , Create a measure like
sumx(summarize(Table, Table[market], table[ID], Table[value]), [Value])
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |