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.
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.