Text value from relatedtable in measure

[Anonymous]

Hi,

I would like a measure that displays the last note (based on date column) in a relatedtable. And only on the first level in the matrix...im guessing some use of ISINSCOPE('Company'[CompanyName])

[Greg_Deckler]

@Anonymous Maybe:

Measure =
  IF(
    ISINSCOPE('Company'[CompanyName]),
        VAR __Date = MAX('Notes'[Date])
      RETURN
        MAXX(FILTER('Notes',[Date]=__Date),[Note]),
      BLANK()
  )

[Anonymous]