Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I use the following RANKX on a Table Visual.
Solved! Go to 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.
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.
Now that I use
What do I need to add if I want to use POLICYESTIMATEDPREMIUM as my tie breaker? Larger $ higher number?
@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
There is some syntax error and I think there is no closing ) somewhere, but I have tried to add it and not getting there,
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