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

Shishir22's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
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

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

    Thanks, Shishir

    It worked

     

    Much appreciated