Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi,
This measure solves the problem
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.
Thanks @Ashish_Mathur, but no luck.
Here is the link.
https://drive.google.com/file/d/1DnCfpNOUR6x1u22aQYxAuePcfR4_6t-N/view?usp=sharing
Best,
Mike
Hi,
This measure solves the problem
This did not solve the core issue.... why marked as solution?
Looks Great. Thank you. Why did we need allselected?
You are welcome. To pay heed to the specific Clinic names chosen in the slicer.
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
Cannot understand. Show the exact problem and also the expected result.
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=sharing
Again, the issue here is in the rank list, all is good.
When I select Patel, her rank falls to 11.
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.
Hi - By any chance did you ever find a solution to this problem?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |