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 !
Cumulative sum from a measure with ranking
Hello to all ! I have the following problem: I have a measurement that is calculated from two others. With this measure, I get the ranking according to projects. I would like to have the cumulative value. For that, I am using this formula which is not really useful for me : **bleep** sale = CALCULATE([Sale], TOPN(RANKX(ALL(Proyect[Name]), [Sale],,,Skip),ALL(Proyect[Name]), [Sale])) This is what I have and this is what I need help with this please.Doing a rank with a column created in variable
Hi everyone, I need to rank the Sales of the Employees, but I have a table and a new column called Test created as a variable in th DAX. This is to improve the performance. I have tried it without and it is taking too long to load, so this is my only solution. The loading time is no problem anymore but now I dont know how to iterate through the new column Test to get the ranking right. I need to use that column (which is a replication of the column Sales) because the column Sales is based on a lot of measures, which is the reason why it takes so long to load. The query is executing but the rankings come out all as 1. It must be due to the SUMX() that just compares every row with itself. How can I fix this? Your help is gretaly apreciated. Measure = VAR table_ = ADDCOLUMNS ( SUMMARIZE ( 'TableEmployee', 'TableEmployee'[Employee], "Sales", 'TableSales'[Sales] ), "Test", [Sales] ) RETURN RANKX( ALLSELECTED( 'TableEmployee'[Employee] ) , ( SUMX(table_, [Test])),,ASC,Dense)
RANKX to show sales rep along with their manager ID
I wanted to show ranking of the sales rep along with their managers. I am using sales (fact) table, it doesnt work Rank - SalesRep = IF(NOT(ISBLANK([Revenue])),RANKX(ALLSELECTED('Sales2022-2025'[SalesRepID]),[Revenue],,DESC),BLANK()) However, if I use employees table, it is working. What is the possible reason for this?Problem when creating a ranking using several tables in Power BI DAX
Hi team. I'm trying to do this, for each couple year-month I need to create the ranking of my revenue. The rankin must restart everytime the year changes. This is an image of my model And this is the formula that I've created: Ranking Revenue = VAR RevenuePerMonth = SUMX('sales', 'sales'[quantity] * RELATED('products'[price])) RETURN RANKX( FILTER( ALL('datedim'), 'datedim'[MonthNo] = MAX('datedim'[MonthNo]) || 'datedim'[Year] = MAX('datedim'[Year]) ), RevenuePerMonth, , ASC, Dense ) However, I'm getting always the same value when I create the table chart using the year and monthNo from the datedim table: What is missing or what is wrong?
Filtered Rank Problem
Have created a standard ranking, which is working fine, using the following: Customer Ranking = rankx(all ('Customer Data'[Sold-to Party Group]),[CY Total Sales],,desc). I am working on a customer profile page where the filter is Sold-to Party Group (field used in the above formula). I am trying to return a simple card showing the customer's rank of all customers. The problem is that the rank is incorrect when using the above formula on the page filtered by customer group. The 2nd ranked customer shows as 3. I am pretty sure the problem is being caused by the page's selection criteria (Sold-to Party Group). Any help woould be greatly appreciated.RankX Ranking Ties
Hello, Can someone help with how to break ties? I have the below dax forumla creating a ranking column in my table using item code that thens ranks by the earliest date. I tried adding dense to the ties portion of the formula and I get this error Ranking = VAR __cd = PO_PurchaseOrderDetail[ItemCode] RETURN RANKX( FILTER( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] = __cd ),PO_PurchaseOrderDetail[PODATE]) Ranking error using Dense: Rtotal = VAR __po = PO_PurchaseOrderDetail[PurchaseOrderNo] VAR __cd = PO_PurchaseOrderDetail[ItemCode] RETURN RANKX( FILTER( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] = __cd ),PO_PurchaseOrderDetail[PODATE], DENSE) Results: Expected Ressult: Thanks so much in advance!
