Adding a Measure to table shows all rows

[f1254lipm]

Hi, I have created a simple RANKX measure to rank comments based on their date: 

RANKX(

   ALLSELECTED(Comments[Comment]),

CALCULATE(MIN(Comments[UpdatedOn])),,ASC))

and when I added this measure to a table or matrix with comments on rows, all comments in the Comments table appeared regardless of applied slicers. Is there a way to fix this?
Thanks,
Filip

[f1254lipm]

Hi @tamerj1, thank you so much! It works. The rows are now filtered correctly and the measure returns the correct rank.

[tamerj1 · Accepted solution]

Hi @f1254lipm 

please try

IF (

NOT ISEMPTY ( Comments ),

RANKX(

   ALLSELECTED(Comments[Comment]),

CALCULATE(MIN(Comments[UpdatedOn])),,ASC))

)