Forum Discussion
Ranking changes when applying filters
Hi,
This measure solves the problem
RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALLSELECTED(BizLine[ProvName]),[Prod/Hr]))Hope this helps.
Thanks for the response.
As you can see, the provider Rubis is ranked 2 prior to any filtering and then when filtered to his name, he is ranked 3.
Afer Filtering, His rank Increases to 3.
I Would like his rank to maintain the rank of 2.
My Current formula for this is:
Hi,
Try this measure
=IF(HASONEVALUE(BizLine[ProvName]),RANKX(CALCULATETABLE(ALL(BizLine[ProvName]),ALLSELECTED(BizLine[ClientName])),[Prod/Hr]))
If it does not, share the link from where i can download your PBI file.
https://drive.google.com/file/d/1DnCfpNOUR6x1u22aQYxAuePcfR4_6t-N/view?usp=sharing
Sorry, here is the link. Thank you so much for looking into this.
Mike
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=sharingAgain, the issue here is in the rank list, all is good.
Patel BeforeWhen I select Patel, her rank falls to 11.
Patel After
I hope you can help.
Many thanks,
Mike
Ashish_MathurHi,
I am sorry but i am unable to identify the cause. I tried but could not succeed.
Hi - By any chance did you ever find a solution to this problem?
