Forum Discussion
f1254lipm
3 years agoFrequent Visitor
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 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
Hi f1254lipm
please try
IF (
NOT ISEMPTY ( Comments ),
RANKX(ALLSELECTED(Comments[Comment]),CALCULATE(MIN(Comments[UpdatedOn])),,ASC)))