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.
Here is a table showing Students, BOSUnits and a sub total for each student which is the sum of BOSUnits. I would like to get the average of each of the subtotals. (In the example shown it would be (10+11+11+11 + etc / n) Also - this is only for 2017. I would also like to be able to compare the average Number of Units done by a student across a number of years.
Not sure how to do this in DAX and would love some help.
Solved! Go to Solution.
Hi @dphillips,
If I understand you correctly, you should be able to use AVERAGEX and SUMMARIZE function(DAX) to create a measure to calculate the average in your scenario. However, without knowing your real table structures, it's hard to write the measure for. So the formula below is for your reference.
Measure = AVERAGEX ( SUMMARIZE ( 'Table1', 'Table1'[Students], "adc", SUM ( 'Table1'[BOSUnits] ) ), [abc] )
Regards
Hi @dphillips,
If I understand you correctly, you should be able to use AVERAGEX and SUMMARIZE function(DAX) to create a measure to calculate the average in your scenario. However, without knowing your real table structures, it's hard to write the measure for. So the formula below is for your reference.
Measure = AVERAGEX ( SUMMARIZE ( 'Table1', 'Table1'[Students], "adc", SUM ( 'Table1'[BOSUnits] ) ), [abc] )
Regards
Thanks - exactly what I was after!
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |