• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count the age less than 18 years

Enan Bahadur

New Member
Hi,
I want to calculate the age of the players who are less than 18 years old.
i have made attached DAX but its giving an error.
Please advise.
Thanks alot
 

Attachments

  • DAX_Count.PNG
    DAX_Count.PNG
    3.6 KB · Views: 11
A best practise on this forum is to upload a sanitized sample file. That way the given advice is more straight to the point.
Share formulas using code tags, it's under the insert button.
81842

Couple of things I notice:
- "&&" is a shorthand for "AND" statement. "<18" would be enough.
- Also the "=" before "<" is strange.

The thread is slightly confusing to me. Title says count the age, in your text you want to calculate age. That could be the average age is 14,5 years for players under 18. Looking at the formula you try to count rows.

You can try
Code:
Age_<18:= countrows ( filter ( TableName , [Payer Age]<18 ) )

81843
 
Last edited:
Back
Top