Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dan--ctvmarks
New Member

Calculate the Employees ages < 18.

Please help me write the correct dax to calculate the Employees who's ages are less than 18.
 
This is what I have --> Employees < 18 = CALCULATE(COUNTAX(Employees, Employees[Age] < 18))
 
Untitled3.PNG
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@dan--ctvmarks  - I don't get the use of CALCULATE in the previous responses, you could do this with a simple FILTER statement.

Measure = COUNTROWS(FILTER('Table',[Age] < 18))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@dan--ctvmarks  - I don't get the use of CALCULATE in the previous responses, you could do this with a simple FILTER statement.

Measure = COUNTROWS(FILTER('Table',[Age] < 18))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
MauriceMecowe
Resolver II
Resolver II

 

CALCULATE(COUNTROWS('Table'), 'Table'[Age] < 18)

 

 

Try this 🙂

amitchandak
Super User
Super User

@dan--ctvmarks ,

Try like

CALCULATE(COUNTAX(Employees, Employees[Age]), filter(Employees, Employees[Age] < 18))

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.