Forum Discussion

f1254lipm's avatar
f1254lipm
Frequent Visitor
3 years ago
Solved

Adding a Measure to table shows all rows

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 measu...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi f1254lipm 

    please try

    IF (

    NOT ISEMPTY ( Comments ),

    RANKX(
       ALLSELECTED(Comments[Comment]),
    CALCULATE(MIN(Comments[UpdatedOn])),,ASC))
    )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi f1254lipm 

please try

IF (

NOT ISEMPTY ( Comments ),

RANKX(
   ALLSELECTED(Comments[Comment]),
CALCULATE(MIN(Comments[UpdatedOn])),,ASC))
)