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.
Hi all,
In the picture below there are id's and their size. I'd like to sum all the sizes of each I'd without grouping in Power Query. I'm thinking about two possibilities but correct me if I'm wrong.
1. Choosing one size for each id and sum them
2. Adding all Sizes for every id and dividing them by the amount of id's
The total must be 10 however and also when adding rows to a matrix.
Thanks in advance!!
Solved! Go to Solution.
Hi @Anonymous,
Try these two measures, please.
Measure = SUMX ( DISTINCT ( 'Table1' ), [Size] )
Measure 2 = SUMX ( SUMMARIZE ( 'Table1', Table1[_ID], Table1[Size] ), [Size] )
Best Regards,
Dale
Hi @Anonymous,
Try these two measures, please.
Measure = SUMX ( DISTINCT ( 'Table1' ), [Size] )
Measure 2 = SUMX ( SUMMARIZE ( 'Table1', Table1[_ID], Table1[Size] ), [Size] )
Best Regards,
Dale
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |