Ranking changes when applying filters

[JellyFishBi]

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:

RankProdHr = IF (
    HASONEVALUE (
        BizLine[ProvName] ),
    RANKX(
         ALL (
             BizLine[ProvName]),NetProd[Prod/Hr]))

Any help would be appreciated.  I have adjusted this formula to exclude HASONEVALUE, i've included dense, skip.  All produce the same behavior...

Thanks,

Mike

[Ashish_Mathur]

Hi,

Assuming Prod/hr is a measure, try this

RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALL(BizLine[ProvName]),[Prod/Hr]))

If it does not help, then share the link from where i can download your PBI file.

[JellyFishBi]

Thanks @Ashish_Mathur, but no luck.

Here is the link.

https://drive.google.com/file/d/1DnCfpNOUR6x1u22aQYxAuePcfR4_6t-N/view?usp=sharing

Best,

Mike

[Ashish_Mathur · Accepted solution]

Hi,

This measure solves the problem

RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALLSELECTED(BizLine[ProvName]),[Prod/Hr]))

Hope this helps.

[PeterChen]

This did not solve the core issue.... why marked as solution?

[JellyFishBi]

Looks Great.  Thank you.  Why did we need allselected?

[Ashish_Mathur]

You are welcome.  To pay heed to the specific Clinic names chosen in the slicer.

[JellyFishBi]

@Ashish_Mathur 

New Problem has arisen.  When I select any other provider with the slicer, they all are ranked 1.  I need them to maintain their rank when filtered by slicer.  How to cope with this?

Man thanks,

Mike

[Ashish_Mathur]

Cannot understand.  Show the exact problem and also the expected result.

[JellyFishBi]

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: 

RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALL(BizLine[ProvName]),[Prod/Hr]))

Using ALLSELECTED returns the Rank to 1 when filtered which is not the desired outcome.

My thanks.

[Ashish_Mathur]

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.

[JellyFishBi]

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

[Ashish_Mathur]

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.

[JellyFishBi]

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 

[Ashish_Mathur]

Hi,

I am sorry but i am unable to identify the cause.  I tried but could not succeed.

[JellyFishBi]

@Ashish_Mathur 
I can send the file again.  Do you still have it from yesterday??

[rcorn]

Hi - By any chance did you ever find a solution to this problem?