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.
Hey guys, super basic question but what would the DAX expression be for finding the average, sum and countdistinct of one column after being grouped by another column.
Example for average:
Column 1 Column 2 Average
Group 1 6 8
Group 1 10 8
Group 2 4 5
Group 2 6 5
Group 2 5 5
Group 3 10 15
Group 3 20 15
Solved! Go to Solution.
Try to use this measure definition
Try to use this measure definition
The easiest way would be to put Column1 in a Table visualization. Then add Column2. In the Values area of the VISUALIZATIONS pane, use the little drop down arrow next to Column 2 to change the aggregation to average, etc.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |