RANKX and Visual Filters

[bdehning]

I use the following RANKX on a Table Visual.  

RANX =

RANKX(

'Prod DW - Business Policy Dimension',

'Prod DW - Business Policy Dimension'[EXMOD1]

)

How do I modify so that is takes into account the filters I have applied to my Table and not across all Column data.   

[bdehning · Accepted solution]

I ended up applying filters to Prod DW - Business Policy Dimension in Power Query and then used my original RANKX and got results in Table Visual in needed.  Seemed it would be too hard to create measures for what I needed without doing that.   

[bdehning]

Now that I use 

RANK =

RANKX(

'Prod DW - Business Policy Dimension',

'Prod DW - Business Policy Dimension'[EXMOD1]

)

I get ties for EXMOD1

What do I need to add if I want to use POLICYESTIMATEDPREMIUM as my tie breaker?   Larger $ higher number?

[amitchandak]

@bdehning , This is column rank, It can not take the slicer filter, You can add filter in formula 

RANX =
RANKX(
filter('Prod DW - Business Policy Dimension','Prod DW - Business Policy Dimension'[Code] in {"1", "2"}
'Prod DW - Business Policy Dimension'[EXMOD1]
)

Or you have to create a measure rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

[bdehning]

There is some syntax error and I think there is no closing ) somewhere, but I have tried to add it and not getting there,   

[bdehning]

I got it to run, it needed ), after the filter.   I filter several things, so when I tried one of the filtered fields the Rank column returned all 1's. 

I have filters

GOVCLASS Text field = 5432

EXMOD1 Decimal Number field > 0

POLICYESTIMATEDPREMIUM General Field > 100000

RANX =

RANKX(

filter('Prod DW - Business Policy Dimension','Prod DW - Business Policy Dimension'[GOVCLASS] in {"1", "2"}),

'Prod DW - Business Policy Dimension'[EXMOD1]

)