Forum Discussion
Solved
Ranking changes when applying filters
Good Evening Folks. My Problem with RANKX is that It ranks my list just fine as shown: BUT When I filter by a Provider, "Reem" in this case, His rank drops to 2 as shown. My Formula is...
Hi,
This measure solves the problem
RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALLSELECTED(BizLine[ProvName]),[Prod/Hr]))Hope this helps.
I am quite sure my formula there is correct. It may have to do something with the relationships. There are way too many relationships to review/check there. Someone else will help you.
Thank you, I have created a watered down, three table version of the report. Here is the link.
https://drive.google.com/file/d/1ZCaqeH3AAStNF-vmf9RV52lfSsRilqJV/view?usp=sharing
Again, the issue here is in the rank list, all is good.
Patel Before
When I select Patel, her rank falls to 11.
Patel After
I hope you can help.
Many thanks,
Mike
Ashish_Mathur
Hi,
I am sorry but i am unable to identify the cause. I tried but could not succeed.