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

Tahreem24thank you for your reply, this is what i have tried although this seems to just look at the latest date by status. Whereas i would need to look at this per Manager ID? so i could create a bar chart to say satus as the axis and the count to be based on the latest date per manager ID how many fit into each status. Does that make sense?

VahidDM's avatar
VahidDM
Super User
5 years ago

Hi,

 

First, September does not have day 31!

second, your question is not totally clear for me, but please check this measure:

measure = 
VAR _MaxDate =
    CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( 'Table', 'Table'[Manager ID] ) )
RETURN
    CALCULATE ( COUNT ( 'Table'[Date] ), 'Table'[Date] = _MaxDate )

Result would be shown as below:

Don't forget to give thumbs up and accept this as a solution if it helped you!!!