Forum Discussion

ldwf's avatar
ldwf
Helper V
4 years ago
Solved

Create a Measure on Text Field

Hello, I have a star schema PBI model.  I have a dimension table with comment field,.  I have a date slicer where the user can select multiple dates from a date dimension table.  I want to use the ma...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    ldwf 

    Except you were filtering the Dim_Date[Date] column while you should be filtering the Dim_Comments[Date] column

tamerj1's avatar
tamerj1
Community Champion
4 years ago

ldwf 

Please use

LatestCommentMeasure =
CALCULATE (
    MAX ( 'Dim_Comments'[Comments] ),
    'Dim_Comments'[Date] = MAX ( 'Dim_Date'[Date] )
)
  • ldwf's avatar
    ldwf
    Helper V
    4 years ago

    I have tried this before as well, but it always returns the maximum comment, not the comment corresponding to the maximum date selected in the slicer.

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      ldwf 

      Except you were filtering the Dim_Date[Date] column while you should be filtering the Dim_Comments[Date] column

      • ldwf's avatar
        ldwf
        Helper V
        4 years ago

        That was it!