Forum Discussion

Enan's avatar
Enan
Helper I
3 years ago
Solved

Count the age Less than 18

Hi   I want to count the age of the players that are less than 18 years old. I have made below measure, but it gives me error. age<18 = CALCULATE(COUNTROWS('fct_Season 2022/2023 Transfer'),'fct_...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Enan 

     

    You can try the following methods.
    Sample data:

    Measure = CALCULATE(COUNT('Table'[Player]),FILTER(ALL('Table'),[Age]<18))

    There is another kind.

    Measure 2 = CALCULATE(COUNT('Table'[Player]),FILTER(ALL('Table'),[Player Age]="<18"))

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

Hi,

I think there is a syntax error on (="<"&&18) part, try the below code Please :

age<18 = CALCULATE(COUNTROWS('fct_Season 2022/2023 Transfer'),'fct_Season 2022/2023 Transfer'[Player Age]< 18)

Thanks for your Kudos and please mark it as a solution if it helps