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 am new to Power BI and have this problem I cannot solve. I have a two columns one with the Gender (Male/Female) and the other column with the Age. My question is how can i make a measure of the average age of Male and Female?
Solved! Go to Solution.
Assuming you've made a measure that works out the average of your column, you just need to apply a filter, something like:
calculate([youraverageagemeasure],genderfield="Male")
should work for you
Not entirely sure how averagex works, and it seems unnecessary compared to plain old average in this case - just make a measure AverageAge = AVERAGE(youragecolumn), then if it works for everything combined, then feed that into other measures as described above
Assuming you've made a measure that works out the average of your column, you just need to apply a filter, something like:
calculate([youraverageagemeasure],genderfield="Male")
should work for you
I have write it like this but it doesn't work:
Average Male = CALCULATE(AVERAGEX('Statistic'; ' Statistic[Gender]="Male"); ' Statistic'[Age]))
Not entirely sure how averagex works, and it seems unnecessary compared to plain old average in this case - just make a measure AverageAge = AVERAGE(youragecolumn), then if it works for everything combined, then feed that into other measures as described above
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 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |