Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count Latest Date

Hi, I have another Dax Measure problem.   I need to create measure, which counts Manager Status in the latest date for each manager ID, additionaly date slicer available on the page should impact t...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

     

    Please check the measure.

    Measure = CALCULATE(COUNT('Table'[ManagerID]),FILTER(ALLEXCEPT('Table','Table'[Status]),'Table'[Date]=MAXX(ALL('Table'),'Table'[Date])))

    Result would be shown as below.

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

Please check the measure.

Measure = CALCULATE(COUNT('Table'[ManagerID]),FILTER(ALLEXCEPT('Table','Table'[Status]),'Table'[Date]=MAXX(ALL('Table'),'Table'[Date])))

Result would be shown as below.

 

 

Best Regards,

Jay