Forum Discussion

YoungLearning's avatar
YoungLearning
Icon for Helper III rankHelper III
2 years ago
Solved

Getting help with this complicated DAX question

  Can someone explain to me why CountRows since the employee name will be recorded for every month he/she stays employed, and why that filter LastDate Date?  
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    The LASTDATE filter will adjust the filter context to only return a single date. COUNTROWS then calculates the employee count for that date (month).

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
2 years ago

Hey YoungLearning ,

 

please provide the pbix that you use, this enables us to be on the same page.

 

"Sum of Headcount Count" doesn't look like a measure is used.

 

Regards,

Tom