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 number  for Max selected year. 

The Head Count measure is already calculated in CalculatedMeasures Table.


2 Replies

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