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 !
Dynamic Top N Parameter doesn't work when adding a LEGEND to a Stacked Bar Chart
Link to pbix: Dynamic TopN with Legend not working.pbix In my sample, I have a horizontal stacked bar chart (Sales by City) that interacts correctly with the dynamic Top N parameter: I used the following rank measure: Rank_City = RANKX( ALLSELECTED('Dim_City'[City]), [Sales Amount], , DESC, DENSE ) And a measure applied to the chart as a filter to activate the dynamic Top N: TopNCity = IF([Rank_City] <= 'TopN'[TopN Value], 1, 0) All is well until adding a sub-category as a legend breaks the dynamic top N: How do I make sure the chart still displays the correct number of cities even with a sub-category applied as a legend? I have attached a link to the sample pbix. Thank you!
Consistent Ranking Measure Ignoring Page Slicers
I am trying to create a ranking measure in Power BI based on a specific variable while ensuring that the ranking remains consistent regardless of any slicers applied on the page. But the ranking changes when the slicer is applied. The ranking should remain the same irrespective of any slicers applied on the page (specifically, slicers for Category). I have tried ALL and ALLSELECTED but the rankings change when I applied the slicers. Here is the measure I used: rank = RANKX(ALL(Table),CALCULATE(SUM(Table[Income]),REMOVEFILTERS(Table[Category])),,DESC,Dense) When I apply the slicer, the ranking position decreases by one spot with this measure. How can I change this for it to work?Top 3 flags being removed
Hi, I'm needing help with a measure to get the top 3 support needs being removed on a month to month basis. I have a transactional table, "CUSTOMER_FLAGS" with customers, "CUSTOMER_FLAGS"[Customer], that have flags against them for support needs "CUSTOMER_FLAGS"[FLAG_ID]. Customers can have one or more flags against them. I have a date table "DATE"[Date], and relevant date columns in my table connected to this are "CUSTOMER_FLAGS"[ACTIVE_AT], "CUSTOMER_FLAGS"[EXPIRES_AT]. The "DATE"[Date] column is connected to "CUSTOMER_FLAGS"[ACTIVE_AT]. I also have "FLAG_REFERENCE" table with "FLAG_REFERENCE"[FLAG_NAME] to define what the flags are, [FLAG_ID] '103' = FLAG_NAME 'I need help with reading' etc and is connected via "FLAG_REFERENCE"[FLAG_ID] to "CUSTOMER_FLAGS"[FLAG_ID]. I need to see on a month to month basis, the top 3 support needs that are being removed; this is to see which support needs customers are needing less over time. I have struggled with this as it's both needing to get the support needs that are being removed over time, not the number of customers, but also with the added necessity to see it as the top 3 being removed. Many thanks in advance, Data-Papa.URGENT!! Ranking measure not working.
Hello Power BI community!Preview Can you help me with the below ranking code? This code is giving me the same ranking for different % of search order columns: SortingOrderSearchOrder_SingleSelect = VAR SelectedProducts = {"Search Order (First)", "Brand First", "Category First", "Flavour Variant First", "Format First", "Not Answered", "Nutritional Content First", "Others First", "Pack Size First", "Pack Type First", "Packaging Design First", "Price First", "Product Origin First", "Promotion First", "Returnable Packaging First", "Temperature First", "Try New First", "Unit Type First" } RETURN IF( max('df_Search Order (First)'[Search Order (First)]) IN SelectedProducts, RANKX( FILTER( ALL('df_Search Order (First)'[Search Order (First)]), 'df_Search Order (First)'[Search Order (First)] IN SelectedProducts ), [Ranking SingleSelect], , ASC ), 0 ) below is a screenshot of the measure - Following are the reference measures used: Category_Occasion_SingleSelect% = [DistinctCount_Category_Occasions_SingleSelect]/ [TotalSum_Category_Occasion_SingleSelect] Ranking SingleSelect = RANKX(ALL('df_Search Order (First)'[Search Order (First)]), [Category_Occasion_SingleSelect%], , DESC, Dense) MFelix , amitchandak , Ashish_Mathur
Rankx with ties
Hello All, I have a ranking issue I can't solve. I have the below table: 1 same group can have multiple dealers. My ranking formula is the following: ranking test = IF(NOT (ISBLANK([Score in %])),CALCULATE(RANKX(ALLSELECTED(Lookup__Dealer), [Score in %], , DESC)), BLANK()) This works well. However, when I add the Region column (coming from a separate dim table), it gives me ties: Suddenly, the dealer who was number 1 became number 2 and the number 2 and 3 both became number 3. Therefore, if in my slicer I select bottom 1, it will show me blank value. I need the bottom 1 to remain 1 when I add the Region column like as below: N Group Dealer Full Name Ranking test score in % Region 125 .......7 3 71,11 FR 573 .......6 2 62,22 NL 573 ........2 1 49,44 NL And If I select the Region NL in a slicer, I need my ranking to adapt iself as below: N Group Dealer Full Name Ranking test score in % Region 573 .......6 2 62,22 NL 573 ........2 1 49,44 NL How could I achive this ? Thanks
