Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have table and i want to create maxtrix in visualizations
with row of matrix table is NAME and value sum of amount with distinct ID and result :
NAME AMOUNT
A 500
B 1100
but i effort write DAX but not result so i wish you guide me.
Thanks you
Solved! Go to Solution.
Hi laitung1991,
You could try to use below measure to see whether it works or not
Measure = SUMX ( SUMMARIZE ( T3, T3[name], T3[id], T3[amount], "sumdistinct", T3[amount] ), [sumdistinct] )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi laitung1991,
You could try to use below measure to see whether it works or not
Measure = SUMX ( SUMMARIZE ( T3, T3[name], T3[id], T3[amount], "sumdistinct", T3[amount] ), [sumdistinct] )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This seems like the sum of the Averages problem. Please, ref the link below. Do count distinct in place of Avg
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
i don't think so, i want just sum not average, the example is created by data raw about 100.000 record and have many diffirence value
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |