Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help on DAX

Hi, I need a help in creating two measures, when two years are selected from year slicer, I want to calculate   Measure-1: the HeadCount number for Min selected year Measure-2: the Headcount numb...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

Try something like this:

MIN_Count = var _minY = MIN(Calendar[Year]) return

CALCULATE(COUNT(Table[Emp_id],ALL(Table[Date]),YEAR(Table[Date])= _minY)




MAX_Count = var _maxY = MAX(Calendar[Year]) return

CALCULATE(COUNT(Table[Emp_id],ALL(Table[Date]),YEAR(Table[Date])= _maxY)



I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for the reply, But if use COUNT(Table[Emp_id],ALL(Table[Date]),YEAR(Table[Date])= _maxY) expression, It will give the wrong Headcount number.

Can't we use Measure (Measure name is HeadCount) directly in the expression?