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.
Hi,
I am having a difficult time trying to pull in these specific Ranks based off the slicer the user can choose.
I have a slicer that selects the "Dealer Number/Group" and I just want it to pull the # Rank of Net Profit $ Dealer.
Thanks for any Help!
Here is my Rankx Function:
I tried something like this too, but it hasnt work in a card slicer:
Solved! Go to Solution.
Hi @Anonymous ,
You can try changing the all function to the allselected function.
Rank, NP $ CY =
If( isblank( [Net Profit $ Dealer]) , blank() ,
RANKX(
Filter( ALLSELECTED(Dealers[Dealer Number/Group]) ,not(isblank([Net Profit $ Dealer]))),
[Net Profit $ Dealer], , DESC))
You can refer to the following documents that may be helpful to you:
Ranking Values with Measures - (powerbi.tips)
DYNAMIC RANKX BY SLICER SELECTION IN POWER BI - Ruki's Blog (rukiatu.com)
How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) - RADACAD
Use of RANKX in Power BI measures - SQLBI
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Share the download link of the PBI file.
Hi @Anonymous ,
You can try changing the all function to the allselected function.
Rank, NP $ CY =
If( isblank( [Net Profit $ Dealer]) , blank() ,
RANKX(
Filter( ALLSELECTED(Dealers[Dealer Number/Group]) ,not(isblank([Net Profit $ Dealer]))),
[Net Profit $ Dealer], , DESC))
You can refer to the following documents that may be helpful to you:
Ranking Values with Measures - (powerbi.tips)
DYNAMIC RANKX BY SLICER SELECTION IN POWER BI - Ruki's Blog (rukiatu.com)
How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) - RADACAD
Use of RANKX in Power BI measures - SQLBI
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |