Rankx with filter ranks all rows

cdcphist 

Add the column as follows:

rank = 
VAR currentcompany ='Table'[company]
VAR currentcategory ='Table'[category]
var currentvalue='Table'[value]
RETURN
IF(
    'Table'[value] <> BLANK(),
    RANKX (FILTER ( 'Table', 'Table'[company] = currentcompany && 'Table'[category] = currentcategory && 'Table'[value]<> BLANK()), 'Table'[value],,ASC)
)

Hi, cdcphist 

Please try something like the below.

rank CC =
VAR currentC = 'Table'[company]
VAR cuurentCat = 'Table'[category]
RETURN
IF (
ISBLANK ( 'Table'[value] ),
BLANK (),
RANKX (
FILTER (
'Table',
'Table'[company] = currentC
&& 'Table'[category] = cuurentCat
&& NOT ISBLANK ( 'Table'[value] )
),
'Table'[value],
,
ASC
)
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM