Mark the cell before specific rank#

[kusanagi]

Hi experts,

Please support my question below.

For [Delete] column, I capture the delete wording by this formula:

Delete = IF([Type]="Delete","Delete",BLANK())

Then I rank the table by [Item#]

Rank = RANKX(FILTER('Table',[ITEM#]=EARLIER([ITEM#])),[MESS#],,ASC,Dense)

I would like to mark the all the cells <= the rank by [Item#] 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

delete CC =
VAR _messnumber =
    MAXX (
        FILTER (
            data,
            data[item_number] = EARLIER ( data[item_number] )
                && data[type] = "delete"
        ),
        data[mess_number]
    )
RETURN
    IF ( data[mess_number] <= _messnumber, "delete" )