Calculate users Count on Age Distribution (18-30,31-45) on X axis

[sb_powerbi]

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 ?

[v-chuncz-msft · Accepted solution]

@sb_powerbi,

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 )

[sb_powerbi]

Thanks Sam,

I have found one more solutoin, We can able add conditions by using Conditional Column feature in query editor.