by Abhijith DSouza | Mar 4, 2022 | Power BI
There are several articles and books written on how to write better DAX and I have written a fair few as well. This article is not one of them. What will cover in this article are some of the best practices associated with DAX management and housekeeping before we...
by Abhijith DSouza | Feb 13, 2022 | Power BI
In the second part of the series on how to solve business problems using DAX we looked at some patterns for calculating averages different grains in the model. In this series we will look at patterns where we need sales amount filtered for a value(s) of an column of...
by Abhijith DSouza | Feb 8, 2022 | Power BI
In Part 1 of the series, we looked at some patterns to solve business problems which involved calculating total sales, maximum discount, unique products sold etc. In this Part, we will look at some patterns which involve calculating averages and also discuss some...
by Abhijith DSouza | Feb 7, 2022 | Power BI
Welcome to the first part of the series on “How to solve problems using DAX”. I spent a lot of time last year posting DAX challenges on LinkedIn which not only covered DAX functions such as CALCULATE, FILTER, TOPN, RANKX but also concepts such as context...
by Abhijith DSouza | Feb 1, 2022 | Power BI
This post is inspired by a blog in which the author showcased the visualisation of % top city sales for a region in Tableau. I thought the solution provided was cumbersome so decided to visualise it in Power BI. It turns out that the DAX for this is straightforward...
by Abhijith DSouza | Nov 20, 2021 | Power BI
Filtering a visual in Power BI by TOPN or BOTTOMN is very easy. You apply a visual level filter and specifiy how many TOP/BOTTOM values you wan to see in your visual. Things get complicated however when there is a hierarchy present in the visual.The TOPN filter will...