So I'm using the RANKX function to rank my networks by my Incentive SAIFI and it works perfect when I'm showing all networks. However when I apply a filter the rank start over. I'm want the networks to keep the same RANK. My latest DAX and example is below. Network Rank = var networks = ALLSELECTED(Hiearchy[Network Name]) return RANKX(ALL(networks), [Incentive SAIFI],,ASC) Raw TableGroup Network Incentive SAIFI Rank (Measure)1A12.3121B12.5141C10.391D13.3162E5.932F7.752G9.972H8.963I11113J3.913K12.8153L6.744M5.724N10.8104O10.284P12.413 Expected When Filtering Group 2Group Network Incentive SAIFI Rank (Measure)2E5.932F7.752G9.972H8.96 What I'm actually getting (with a previous measure, not the one above, I've been trying so many things)Group Network Incentive SAIFI Rank (Measure)2E5.912F7.722G9.942H8.93 Thanks in advance for the help.

That didn't work for me and still the table is much bigger than I'm letting on. I don't want to just post the full raw table with company info. I would have loved to have gotten this working with a measure but I gave up and created a calculated table. Below was my calculated table. Network Rank = UNION( SUMMARIZE(CALCULATETABLE(VALUES(Hiearchy[Network Name]), Hiearchy[Group] = "Group1", Hiearchy[Network Name] <> BLANK()), Hiearchy[Network Name], "Rank", RANKX(ALLSELECTED(Hiearchy[Network Name]), [Incentive SAIFI],,ASC,Skip)), SUMMARIZE(CALCULATETABLE(VALUES(Hiearchy[Network Name]), Hiearchy[Group] = "Group2", Hiearchy[Network Name] <> BLANK()), Hiearchy[Network Name], "Rank", RANKX(ALLSELECTED(Hiearchy[Network Name]), [Incentive SAIFI],,ASC,Skip)), SUMMARIZE(CALCULATETABLE(VALUES(Hiearchy[Network Name]), Hiearchy[Group] = "Group3", Hiearchy[Network Name] <> BLANK()), Hiearchy[Network Name], "Rank", RANKX(ALLSELECTED(Hiearchy[Network Name]), [Incentive SAIFI],,ASC,Skip)), SUMMARIZE(CALCULATETABLE(VALUES(Hiearchy[Network Name]), Hiearchy[Group] = "Group4", Hiearchy[Network Name] <> BLANK()), Hiearchy[Network Name], "Rank", RANKX(ALLSELECTED(Hiearchy[Network Name]), [Incentive SAIFI],,ASC,Skip)), SUMMARIZE(CALCULATETABLE(VALUES(Hiearchy[Network Name]), Hiearchy[Group] = "Group5", Hiearchy[Network Name] <> BLANK()), Hiearchy[Network Name], "Rank", RANKX(ALLSELECTED(Hiearchy[Network Name]), [Incentive SAIFI],,ASC,Skip)) )

Using RANKX with Filtered Column | Microsoft Fabric Community

Forum Discussion

Related content

Slicer for filtering several columns

Filter data using slicer

Using measure as a filter

Clustered Column Using Inscope

Dynamic filter using lookups