Creating age groups

[lastnn30]

Hi

I have list of ages (18-60) and I want to group them like (by 10)

18 - 28

29 - 39

40 - 50

51 - 60 

I want to use PowerBI not Power Query. I tried to create Bin or List but I did not get it right. Any idea please. Thank you so much

[Fowmy · Accepted solution]

@lastnn30 

Create a table as follows names Band Table

Create a measure count the ages:

Count Age = 
VAR __AgeBandMin = SELECTEDVALUE('Band Table'[Min] ) 
VAR __AgeBandMax = SELECTEDVALUE('Band Table'[Max] )
return
CALCULATE(
    COUNT(Table2[Age]),
    Table2[Age] >= __AgeBandMin,
    Table2[Age] <= __AgeBandMax 
)

Result

The file is attached below my signature

[Fowmy · Accepted solution]

@lastnn30 

Create a table as follows names Band Table

Create a measure count the ages:

Count Age = 
VAR __AgeBandMin = SELECTEDVALUE('Band Table'[Min] ) 
VAR __AgeBandMax = SELECTEDVALUE('Band Table'[Max] )
return
CALCULATE(
    COUNT(Table2[Age]),
    Table2[Age] >= __AgeBandMin,
    Table2[Age] <= __AgeBandMax 
)

Result

The file is attached below my signature

[lastnn30 · Accepted solution]

Thank you so much indeed.