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.
We got requirement to show the users count with age distributions. For example we have to show the users count by age between breakups . X axis values should be : 18-35 , 36-50,51-64, 65>above. Y axis : users count. Please suggest us how to calculate users count based on age breakups ?
Solved! Go to Solution.
Here is one way for your reference.
1) add a caculated column AgeGroup
AgeGroup = IF ( Persons[Age] < 18, "1) <18", IF ( Persons[Age] <= 25, "2) 18-25", IF ( Persons[Age] <= 50, "3) 26-50", "4) >50" ) ) )
2) add a measure UsersCount
UsersCount = COUNTX ( Persons, 1 )
Here is one way for your reference.
1) add a caculated column AgeGroup
AgeGroup = IF ( Persons[Age] < 18, "1) <18", IF ( Persons[Age] <= 25, "2) 18-25", IF ( Persons[Age] <= 50, "3) 26-50", "4) >50" ) ) )
2) add a measure UsersCount
UsersCount = COUNTX ( Persons, 1 )
Thanks Sam,
I have found one more solutoin, We can able add conditions by using Conditional Column feature in query editor.
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |