Forum Discussion

rahul_ferns's avatar
rahul_ferns
Icon for Helper II rankHelper II
4 years ago
Solved

Measure to show Latest Data based on Filter

Hi Experts I am trying to create a measure that will give me the latest LTI description based on a filter, I have created a measure using MAX but if doesn't give me the latest description (I think i...
Need Help
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello rahul_ferns ,

     

    Please try creating measure as-

    Measure = 
Var A = MAXX(Filter(ALLSELECTED('Incidents_Data'),'Incidents_Data'[Incident Type]="Lost Time Injury" ),'Incidents_Data'[Date])
Var B = CALCULATE(FIRSTNONBLANK('Incidents_Data'[Incident Description],0),FILTER('Incidents_Data','Incidents_Data'[Incident Type]="Lost Time Injury" && 'Incidents_Data'[Date]=A))
Return
B

     

    Please mark it as solution if it solves your requirement. Kudos are also appreciated.

     

    Thanks,

    Shishir

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

rahul_ferns , Max selected date in slicer

measure = maxx(allselected(Table), Table[Date])

 

or

 

measure = maxx(allselected(Date), Date[Date])

  • rahul_ferns's avatar
    rahul_ferns
    Icon for Helper II rankHelper II
    4 years ago

    amitchandak 

    That didn't work

    Getting the below error

     

     

    I also need to filter by only Lost Time Injury, it should only show the latest Incident Description if the Incident Type is Lost Time Injury

     

    Regards

    Rahul