Forum Discussion
RANX Issues
I FIGURED IT OUT!!!!! Oh my gosh, such relief right now, it was such a simple fix.
I changed the grouping from role to name and then added a filter to the visual for the group I was looking for. Thanks for all of your help. 🙂
Difficult to troubleshoot without example data. Perhaps this will help: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
Otherwise, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Thank you for the valuable links. Hopefully this will help you further. I did try the suggestions you provided with the "what the hell ranx" formulas to no avail.
Sorry, the invoiced sales data is also a line by line detail of who placed what order and the amount the order was sold for. This is the current formula being displayed in the image above.
I FIGURED IT OUT!!!!! Oh my gosh, such relief right now, it was such a simple fix.
I changed the grouping from role to name and then added a filter to the visual for the group I was looking for. Thanks for all of your help. 🙂