The ALLSELECTED function inside of Power BI is a complex DAX function. It is one of the more advanced functions that you can utilize within your reports and dashboards. In my view, it is one that you have to learn well. You can’t just forget about it and not focus on ways you can utilize
In this tutorial, we are going to dive into on how to utilize the RANKX function effectively in Power BI. Sometimes you don’t want to show all of the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the
Recently during an Enterprise DNA webinar series session, I dived into how you can showcase deviations in your data in a compelling way. It’s all about setting up compelling visualizations and making sure that we have our results calculated correctly. This is what this video tutorial is all about. I want to showcase how you
In this example we’re going to get quite advanced in Power BI using DAX. We are going to try and segment our dimensions. We will segment some table in our data by the ranking of a dimension in that particular table. There’s a little bit to this but it’s a really amazing concept of how
Through this really unique and specific example I’m going to dive into how you can combine lots of the techniques that I’ve described in many tutorials and posts in the past. These are techniques like Measure Branching, Trend Analysis, and DAX formula combinations. What we are going to do is analyze the changes to profits
