Forum Discussion

aabati68's avatar
aabati68
Frequent Visitor
2 years ago
Solved

Please help with CALCULATE and FILTER dax function

I know the way I am trying to solve this is not elegant at all, but I do have a simple table called "HR Data" and a measure define like this: Headcount Employees = CALCULATE(DISTINCTCOUNT('HR Data'...
  • lbendlin's avatar
    lbendlin
    2 years ago

    Heacount Employees One Year Before = CALCULATE(sum('HR Data'[Headcount Employees]),OFFSET(-4,allselected('HR Data'),MATCHBY('HR Data'[Index])))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

aabati68's avatar
aabati68
Frequent Visitor
2 years ago

Thanks, this is the expected outcome:

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Heacount Employees One Year Before = CALCULATE(sum('HR Data'[Headcount Employees]),OFFSET(-4,allselected('HR Data'),MATCHBY('HR Data'[Index])))
    • aabati68's avatar
      aabati68
      Frequent Visitor
      2 years ago

      Wonderful, works really well, thanks a lot !

      A.