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 Please find the sample pbix file and Expected output. Here i want to show Top 50 providers on rank wise while sorting the paid amount. Here am using table visual with diffrent dimenssons and Facts.
Note: Here my orginal source is tabular model so i can't create index column so we need to apply dax to show ranks top 50 records(like need to add incremental column) , i have already filtered out Top 50 records just i want show one column for Ranks.
Solved! Go to Solution.
Hi Harsh Thanks for giving reply, Iam using same query which you sent but Still it's displaying duplicates ranks. I undestand might be you are using Network Licence[ Network Licence key] column but orginal report i amNot using any key column, and it should be Network Licence[Network Licence Number]. While am using this column am getting error. Please suggest me how Can i get the Ranks.
Hi @Narayana3635 ,
https://drive.google.com/file/d/1Ys6MLP74cF_L_16i3lPFSe5CZDubZX6g/view?usp=sharing
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @Anonymous ,
Create the below measures.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Harsh Thanks for giving reply, Iam using same query which you sent but Still it's displaying duplicates ranks. I undestand might be you are using Network Licence[ Network Licence key] column but orginal report i amNot using any key column, and it should be Network Licence[Network Licence Number]. While am using this column am getting error. Please suggest me how Can i get the Ranks.
Hi @Anonymous ,
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @Anonymous ,
https://drive.google.com/file/d/1Ys6MLP74cF_L_16i3lPFSe5CZDubZX6g/view?usp=sharing
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Harshat, This is working fine but when we have parameter selection the data is not filtered can you please help me.
@Anonymous ,
What parameter are you selecting ?
Regards,
HN
Hi @Narayana3635 ,
https://drive.google.com/file/d/1Ys6MLP74cF_L_16i3lPFSe5CZDubZX6g/view?usp=sharing
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Thnka Harsh, You Made by day. It's time to kudos to you.
Hi @Anonymous
I don't like your SUMMARIZE() statement https://docs.microsoft.com/en-us/dax/summarize-function-dax
it has to contains of "name" argument, I don't see it on the screenshot
@Anonymous ,
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Hi amit, I gone through the links still i didn't find the my exact solution. If you are able to help me please find the sample data and expected output on my orginal post.
Hi @Anonymous
try a measure
Measure rankx =
RANKX(
ALL('Fact_Claim_Base_Vw'[Name]),
CALCULATE(SUM('Fact_Claim_Base_Vw'[Paid Amount]))
)
Hi Please refer the attached pbix file, what ever the solution you given it wont work becacuse name came from different table. I tried all the possible ways and seeking help.
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 | |
106 | |
105 | |
86 | |
72 |