It’s a great video and it has helped me a lot! Just one question - can we make rank ignore null values in a column that is passed as a parameter? Currently I have an additional visual filter that uses sync with a condition that this visual filter is greater than 0, but it doesn’t work as expected with rank function you’ve described (it filters out the value and I get rank 1-9 instead of rank 1-10 as in condition😢)
Outstanding!!!! your tricks and tips helps a lot to me. Very Informative. Thank you so much, One more help is it possible to show TopN + others also in the same way. By selecting dynamic top N your measure and parameter gives the exact output, that is if we select 5 then we are getting the top 5 and the other customers are to be grouped as "Others" and need to sum all the value under others. if possible please post that video, will learn it from you.
Hi! Love this method to show top N, many thanks! I've memory problems not allowing me to move on with this scenario. Query's not running with PRO license
When you are in local Power BI desktop, Memory problem is related to the RAM used from your computer. if you are getting, out of memory error for a particular visual, then you may need to recheck the DAX expressions used in it. Follow the best practices while authoring DAX expression or data model
Thanks for the video, very helpful. My question is how to apply this to a multi-select slicer? For example, if you selected both product and customer name it get the ranking based on the combination, then what would need to be done?
Hi! thank you for this very informative Video. Question : I have a stacked bar line chart, bar shows values and line shows percentage. I have also used parameters so i can choose fields i want to show in my bar chart. But I am having issues with the top N values. For example I put a field in the legend then selected top 10, but it is showing me more than 10 items.
Thanks for watching. Answer to your query - Did you use the technique used in this video?. you may need to check your Rank measure if it is giving correct ranking for those fields or not.
Amazing video! I'm using it to toggle between 3 different measures by 1 dimension, Channel. But, let's say I want to have a trended line chart with the same 3 measures to toggle between and the Channel as the series, but the Month dimension comes into the picture. Using this solution, I end up getting the top N individual data points for each month, rather than the top N channels over the 12 month span. Any thoughts here?
I realized that if I want to simply do a top 5, I can just filter that visual to Top 5 Channels by Rank. But what if I want to make this fully dynamic is the real question :)
Thanks for watching. The key here is to create the Ranking depending on your requirements. so you need to modify the Ranking measure. in this example RANKX() is using only Allselected Customers to assign the rank. you can modify to generate a proper rank for your scenario.
No issue with multiple KPIs. but you need to decide on what basis you want the ranking to be created, if you want it be based on multiple conditions. you can also use new RANK() function
@@samuelkiarie325 You can create a single measure by validating many different ways to create the final Rank measure. if needed you may create a measure table as well and then Utilise SWITCH() and SELECTEDVALUE() Function to validate each and every condition for various set of combinations in the final evaluation context.
Question about dynamic filter: what if I want to rank by MoM Changes and MoM % changes besides absolute amount, how could I modify the DAX? create two more measures, one for MoM and second one for MoM%? thank you! Dynamic Filter = VAR _selectednumber = SELECTEDVALUE('Top N'[Top N]) RETURN IF( ISFILTERED('Top N'), INT( [Rank]
You should use && between each conditions. however, you can actually create a single measure which creates a combined rank, based on multiple measures. you can use new RANK() function. I have posted a video on that. please check it out.
Making DAX to works our way is not always straight forward. I have posted videos regarding using measures as filters. the hint is to make the measure to return true or false value for any expression, and then convert it to 0/1 using INT() then we can use it for visual level filters.
Your video was perfect. Just missed one thing that i needed and believe me I tried a loooooot. How the hell do I transform the other values for the dimension into "other" and again sum the measure as it was done at the top 5.
Glad you liked it!I have posted other video related to show top 5 and Others. This Others is expandable in the Matrix visual to see what all products contributes to the "Other" Please check it out
It should work in any visual, however we need to understand the how column headers and row headers are creating the evaluation context for any particular DAX
You may need to cross check your DAX expression for errors, and you should also look into the datamodel to understand more how your expression is working
Do you see any issue in your semantic model? you need to carefully look into the model to know weather these dimensions are accessible through the kind of relationships you have b/w the tables
@@PowerBIHelpline i had my senior BI analyst take a look at it, and we're both still stumped. idk maybe i need to break it down 1 by 1. i might just not mention it and wait if anyone realize haha
