Rank/RankX of Measure in a Matrix
I am trying to use a scatter plot to draw a "periodic table" of asset class return by calendar year (similar to the target output picture). In order to do so, I need to first rank the returns in each calendar year. I tried using RANKX but I could not get the expected results (in green letter). Can you shed me some light how can I fix my DAX code please? I have attached my Power BI file in the link below. Thanks in advance. My Pbix file: https://limewire.com/d/BpJDt#VVxFzw3wCR
Rank basing on measure with parameter & Rank percentile
Hi Everyone, 1) I have created following measure in DAX: Model score weighted FA Table = [Productivity FA table Value] / 100 * AVERAGE(act_source[team_prod_model_score]) + (100 - [Productivity FA table Value])/100 * AVERAGE(act_source[fa_prod_model_score]) Where [Productivity FA table Value] is defined by What-If parameter as following: Productivity FA table = GENERATESERIES(0, 100, 50) Now I am strugling to prepare rank field using above measure. Basically I am trying to find equivalent of Rank_Unique() function in Tableau, which look like as follows: 2) Similar question related to ranking. I have field in my data called [surv_model_score]. I want to apply almost exactly same formula of Rank_Unique as above. Additionaly, on the output, I want to apply equivalent of Rank_Percentile() function as follows: Is there any way to get equivalent of rank_percentile in my case? Thanks and Merry Christmas !
Stacked Bar chart: Group legend values
Hi folks, I have a stacked bar chart with products as a legend. There are a lot of products in my data. Therefore does not show all and gives this hint Personally i think this is crazy because the user will not even read this and see a wrong revenue: But ok, it is what it is. I tried to create a RANKX measure an show only the biggest legend values and group everything else as "Other" But Power BI will not let me put a measure in the legend... Any ideas?
RANK Dax issues!
Hi all, I have the following dataset at my disposal and I'm looking at ranking the SumColumns shown in the dataset after a specific date of 2024, 9, 8 but as you can see there are duplicate values in the sum columns created (dax shown underneath) - and creating this rank measure would also mean dates before 2024, 8, 9 would need to be excluded. I included my current solution underneath these photos that duplicates the table, however I would want to avoid this and just write a new Dax with a new date in when the time comes to change ranges. Duplication solution: Thanks for your help in advance! Jordan
Rank SKIP paramter will not skip after ties
I am trying to use the rank function to rank weekly points. I want the ranking to skip a value after ties. I entered the SKIP parameter but it is not skipping after ties. See screenshot below. What am I doing wrong? If i put the 'All Scores' table as the second parameter I get a circular reference error.How to show top 5 providers and top 5 services for each of these providers
Hi, I have this long list of provider names and services they provide. It's over 4k rows. Something similar to this: This is what I'm trying to achive: I have tried creating a new table using summarize and topN. I have also tried Rank and Ranxk. When it ocmes to ranking I got worng reuslts or all of the rows were showing value of 1. Please help.
