• 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


  • 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
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


GraH - Guido

Well-Known Member
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.

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
Age_<18:= countrows ( filter ( TableName , [Payer Age]<18 ) )
Last edited: