Tag: ALLSELECTED function

DAX Language Power BI Tutorial On Reverse TOPN

In this blog post, we are going to take a look at a question that was asked on the Enterprise DNA forum and use a DAX language Power BI technique in order to solve it. In case you want to follow along and download the files, just visit the Enterprise DNA forum and go to

Continue reading

Power BI Tip: How To Compare First N Business Days

For this post, I would like to talk about a recent Power BI tip that I came up with for a member of the Enterprise DNA forum. The question dealt with a useful pattern in terms of looking at the first N business days or first N billable days of a given month versus the

Continue reading

A Power BI DAX Tutorial On Cumulative Comparisons

A Power BI DAX Tutorial On Cumulative Comparisons

In today’s Power BI DAX tutorial, I want to go over quite an interesting technique that uses DAX really effectively. I had to work on a scenario where we were running some analysis on our email campaigns. I wanted to know how many emails we receive in a day, compare it on a monthly basis,

Continue reading

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like

Continue reading

DAX Examples In Power BI – Advanced DAX Formulas

In this tutorial, I’ll show you some advanced formulas and DAX examples using different functions in Power BI. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. But before you begin, make sure to optimize your measures. I always recommend using measure groups to make

Continue reading